Thread: 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!

=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" <Alicia@discussions.microsoft.com> wrote in message
news:DF7DFBD1-3D23-4629-88E7-9B88847D3E1B@microsoft.com...
> 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!