=SUMPRODUCT(Units,Prices)
Let's say cells A2 to A9 holds a list of units sold per order. Let's also say cells B2 to B9 holds a list of sales prices for each order. The sum product formula as shown adds up the total of cells A2 to A9 and multiplies it by the sum of cells B2 to B9. So if the total value of cell range A2:A9 is 10 and the total value of cell range B2:B9 is 30. The sum product value would be 300.
E.G.:
=SUMPRODUCT(A2:A9,B2:B9)
Let's say cells A2 to A9 holds a list of units sold per order. Let's also say cells B2 to B9 holds a list of sales prices for each order. The sum product formula as shown adds up the total of cells A2 to A9 and multiplies it by the sum of cells B2 to B9. So if the total value of cell range A2:A9 is 10 and the total value of cell range B2:B9 is 30. The sum product value would be 300.
E.G.:
=SUMPRODUCT(A2:A9,B2:B9)
0 comments:
Post a Comment