View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alicia Alicia is offline
external usenet poster
 
Posts: 34
Default 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!