Search code examples
excelcsvexcel-2010excel-2007

Sum column based on condition based on corresponding column in excel


There are two column

A B
1 1

2 1

3 3

Now I want to sum column A if A-(B+C) is equal to 0.

so for above example sum would be 1+3 = 4


Solution

  • Adjust ranges as necessary:

    =SUMPRODUCT((A1:A3=B1:B3)*A1:A3)