Need help with a formula...

[jjaeger]

I need some formula help. I need a formula to do product x Cost. I know how to multiple and get each individual product total cost, and then sum down, but I need it to do the calculation all in one formula...keep in mind I have ~1000 rows of data. Again, the goal is to calculate in 1 cell....

Any help is appreciated

Example
col a col b col c
# products cost
a 1 2.33
b 2 1.24
c 5 1.30
d 11 4.32

Product x Cost

 

[barry houdini]

Try SUMPRODUCT, it does exactly that, e.g.

=SUMPRODUCT(A2:A1000,B2:B1000)

 

[BrandonWLH]

What about hide the column with all the =b#*c#
or put it on another sheet and hide the sheet and sum total there and just reference the sum and bring it to the front page.

None of those options viable?

ack... slow typing, i got houdinid. I really need to learn more of the sheet functions. Thats very simple barry.