sum and product, but not sumproduct?
 

Hi Everyone, here's my issue:

I have 3 columns.
Column A is a macro pull-down list of product options (in this case,
personal training packages - 5-pack, 10-pack, etc).
Column B is a VLOOKUP function that returns the price of the selected product.
Column C is the number of that product a trainer sells (entered manually).

So, trainer Joe Smith sells client Jane Doe two 10-packs of sessions at $740
each.
Column A = 10
Column B = $740
Column C = 2

Each row is a different sale for a different client.

At the bottom of Column C, I need to display the trainer's total sales in
dollars. Is there a simpler way to do this than
(B1*C1)+(B2*C2)+(B3*C3)...etc all the way to (B25*C25)? I just need a
cleaner function.

Thanks!

sum and product, but not sumproduct?
 

=SUMPRODUCT(B1:B25,C1:C25)

will do the (B1*C1)+(B2*C2)*etc



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com





"Alicia" wrote in message
...
Hi Everyone, here's my issue:

I have 3 columns.
Column A is a macro pull-down list of product options (in this case,
personal training packages - 5-pack, 10-pack, etc).
Column B is a VLOOKUP function that returns the price of the selected
product.
Column C is the number of that product a trainer sells (entered manually).

So, trainer Joe Smith sells client Jane Doe two 10-packs of sessions at
$740
each.
Column A = 10
Column B = $740
Column C = 2

Each row is a different sale for a different client.

At the bottom of Column C, I need to display the trainer's total sales in
dollars. Is there a simpler way to do this than
(B1*C1)+(B2*C2)+(B3*C3)...etc all the way to (B25*C25)? I just need a
cleaner function.

Thanks!