|Total Sales Value :||526||=SUMPRODUCT(D4:D6,E4:E6)|
What Does It Do ?
This function uses at least two columns of values. The values in the first column are multipled with the corresponding value in the second column. The total of all the values is the result of the calculation.
=SUMPRODUCT(Range1, Range, Range3 through to Range30)
No special formatting is needed.
The following table was used by a drinks merchant to keep track of stock. The merchant needed to know the total purchase value of the stock, and the potential value of the stock when it is sold, takinging into account the markup percentage.
The =SUMPRODUCT() function is used to multiply the Cases In Stock with the Case Price to calculate what the merchant spent in buying the stock.
The =SUMPRODUCT() function is used to multiply the Cases In Stock with the Bottles In Case and the Bottle Setting Price, to calculate the potential value of the stock if it is all sold.
|Product||Cases In Stock||Case Price||Bottles|
|Bottle Cost||Markup||Bottle Selling Price|
|Total Value Of Stock :||£7,440||=SUMPRODUCT(C35:C39,D35:D39)|
|Total Selling Price Of Stock :||£9,790||=SUMPRODUCT(C35:C39,E35:E39,H35:H39)|