CODEWITHSUNDEEP
excelexcel-formulasumifs
Robin
Robin

Reputation: 198

Excel: Sum based on criteria (SUMIF)

I'm trying to do a sum in an Excel table, but I can't figure out how to do it.

The table should look like this with the last column (Remaining) counting down the remaining budget:

      A        B         C        D

1     Project  Budget    Costs    Remaining 
      -------------------------------------
2     A        110.000   10.000   100.000
3     B        25.000    100      24.900
4     A        110.000   12.000   88.000
5     A        110.000   1.000    87.000
6     B        25.000    1.000    23.900

I really hope you can help me out.

Upvotes: 1

Views: 67

Answers (1)

CFO
CFO

Reputation: 288

Formula in cell D2, and copied down:

=B2-SUMIF(A$2:A2,A2,C$2:C2)

Upvotes: 1

Related Questions