LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"