Have a row of prices and next row quantity and they are all different amounts is there a way to figure totals?

Answer 1

If each pair refer to the same item, then you could multiply each quantity by its corresponding price to get totals for each item, and then add these together to get an overall total.

So if the quanity of product A was in B2 and its price in B3, then in B4 you would put the following formula:

=B2*B3

If you copied that along row 4, assuming the other quantities were in row 2 and prices in row 3, then you would get the total prices for each. If the totals went from B4 to X4, then in Y4, you would have the following formula to get the overall total:

=SUM(B4:X4)

You could also use the SUMPRODUCT function in Y4, without needing to get the individual totals. You would use it in this form:

=SUMPRODUCT(B2:X2,C2:X2)