QTY x PRICE List

[Jameswaitforitdavis]

I was attempting to make a grocery list with a total of prices at the bottom, which works. I would like to add a QTY function that multiplies the price by the QTY and adds to total instead of just totaling. I tried to sum like the example below, but once completed forgot to realize I had to do that for 7 more categories... oops. I don't know how to copy complex formats like that.

If anyone could help me out much would be appreciated.


=SUM((C3*D3)+(C4*D4)(C5*D5)+(C6*D6)+(C7*D7)+(C8*D8)+(C9*D9)+(C10*D10)+(C11*D11)+(C12*D12)+(C13*D13)+(C14*D14)+(C15*D15)+(C16*D16)+(C17*D17)+(C18*D18)+(C19*D19)+(C20*D20)+(C21*D21)+(C22*D22))

[Pete_UK]

You can simplify that to this:

=SUMPRODUCT(C3:C22,D3:D22)

Hope this helps.

Pete

[scottiex]

It looks like you really want to write

Please Login or Register  to view this content.

in oyur location at the bottom of the table for columns C and D.

then just copy it and paste in the appropriate cells the column references will change when you move it.