In order to calculate sum of stock lists we will multiply the quantity with price of stock, we will use SUM & SUMPRODUCT function to get the output.
SUM: Adds all the numbers in a range of cells
There can be a maximum of 255 arguments refer below screenshot:
SUMPRODUCT: Returns the sum of the products of corresponding ranges or arrays.
There can be maximum of 255 arrays in Sumproduct function refer below screenshot
Let us take an example:
In order to calculate the Price after multiplying each cell value from Stock List with the corresponding Qty&then take sum of all the prices, we can use SUM & SUMPRODUCT functions.
1. Price = Stock List x Qty
2. Copy the formula to below range of cells & then take total of all the Price
Column A contains list of stock. Column B contains quantity. Column C contains stock price. In order to calculate the price we need to calculate the sum by multiplying quantity & price & then take sum.
There is another way by which we can find the same result by using SUMPRODUCT function.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.