Multiply columns and sum row?

[jt76]

OK
I have a list of items starting in A1 down to A?, I have the associate
costs of those items in Column B1 down to B?, and the quantity of thos
items ordered starting in C1 down to C?. What I need is a formula tha
will tell me the total cost of what that client ordered

+-------------------------------------------------------------------
|Filename: sum 3.bmp
|Download: http://www.excelforum.com/attachment.php?postid=4315
+-------------------------------------------------------------------

 

[SteveG]

Where are you identifying your clients? Are they combined or in
separate sheets? If each range is for one individual client then just
have column d multiply your Quantity times the cost for each item and
sum column d where you want the total to be.

Steve

 

[baltobernie]

Create column D1 to D?
Create formula in D1
=PRODUCT(A1,B1)
Copy formula in cells D2 to D?
In cell below D? Click AutoSum on the Standard toolbar, and then press
ENTER.

baltobernie
(now will someone please answer My question?)

 

[baltobernie]

Correction:

formula in D1
=PRODUCT(B1,C1)
etc.

Create column D1 to D?
Create formula in D1
=PRODUCT(A1,B1)
Copy formula in cells D2 to D?
In cell below D? Click AutoSum on the Standard toolbar, and then press
ENTER.

baltobernie
(now will someone please answer My question?)

 

[jt76]

Thanks for the help. But Im trying to avoid a Column D multiplier. I
would like, if its possible to do the multiplication and the summing
all in one cell. The reason for this is if I make a column D than I
will have to manually select the area I want to print out othere wise
Excell will print a bunch of pages I dont need (column D). I was
hoping there was a way to use the product command along with a sum
command and do both in one cell.

Thanks for all your help

 

[swatsp0p]

Try Sumproduct, e.g.

in C?+1 =SUMPRODUCT(B1:B?,C1:C?)

HTH

Bruc

 

[jt76]

That is excatly what I needed, this Forum always pulls through for me.

Thanks.

 

[swatsp0p]

I'm glad it worked for you. Thanks for the feedback, it is always
appreciated.

Cheers!