How to do this?

  • Thread starter Thread starter Bob H
  • Start date Start date
B

Bob H

Hi, this should be easy, but I have a mind block and cannot think how to
do this:
I have a column with numbers in, ie 1, 4, 12 etc, and another column
with a price each in. At the bottom of the price column I have the total
cost, but this is only for 1 item.
How can I multiply the number of items by each cost in each row so as to
give me a complete total of ALL items.

I hope this is clear.

Thanks
 
Numbers in A1:A20, prices in B1:B20, total cost =SUMPRODUCT(A1:A20,B1:B20)
best wishes
 
Harald said:
Hi Bob

=SUMPRODUCT((A1:A10)*(B1:B10))

HTH. Best wishes Harald

Hi, this should be easy, but I have a mind block and cannot think how to
do this:
I have a column with numbers in, ie 1, 4, 12 etc, and another column
with a price each in. At the bottom of the price column I have the total
cost, but this is only for 1 item.
How can I multiply the number of items by each cost in each row so as to
give me a complete total of ALL items.

I hope this is clear.

Thanks
Click to expand...
Thanks, thats done it.
Click to expand...
 
Back
Top