Sum of select lines

[seyss]

Hello,

I'd like to calculate the sum of "Total Cost" of each "Area".
Example: "Total Cost" of "Area A" is 60.

PS: I have a 1000-lines long list so let's not use a simple addition formula.

Best regards,
Gabriel Klein

 

[bbott]

Assuming your data is in columns A through D, put this in cell E1 and copy down:

=IF(A1=A2,"",SUMIF(A:A,A1,D:D))

The sum of A will appear in the last row of A, the sum of B in the last row of B, etc.

 

[seyss]

Thanks for the help!



Actually I made a mistake.. I won't have the column D available, so I'd have to multiply the values on column C with the values on column B.



Can it still be done with SUMIF?



Thank you.

 

[bbott]

Put this formula in cell D1:

=IF(A1=A2,"",SUMPRODUCT(--(A:A=A1),B:B,C:C))

Copy down. It should give you the same output.