Search code examples
excelexcel-formulasumifs

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.

Solution

  • Formula in cell D2, and copied down:

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