Conditional SUMIF

[Savitri]

Hi,

The scenario:

Column A Column B Column C
0.1159 127.00
0.1159 11.55
0.1159 11.55 ?
1 2,200.00
1 185.00
1 140.00
1 102.50
1 12.73 ?





Question: Is there a SUMIF formula for Column C that will add the values of Column B given the values in Column A are the same?

I would be grateful for any assistance please.

[DonkeyOte]

You mean like SUMIF ?

C1: =IF(A2=A1,"",SUMIF(A:A,A1,B:B))
copied down

[Savitri]

Your suggestion has worked.

Thank-you.