Search code examples
excelexcel-2013worksheet-functionsumifs

SumIF() Returning 0 Even If I manually Sum() It Is > 0

I want to match the value in Sheet1!A to Sheet3!A and where they match SUM() the matching values in Sheet2!B

I tried this formula, but it is returning a 0 value even when a manual count returns > 0.

What did I set-up incorrectly in this formula?

=SUMIF(A:A,Sheet3!A:A,Sheet3!B:B)
Solution

  • Use this:

    =SUMPRODUCT(SUMIF(Sheet3!A:A,$A$2:INDEX(A:A,MATCH("zzz",A:A)),Sheet3!B:B))

    If you column A is numbers and not text change the "zzz" to 1E+99.

    Edit

    By you comments put this in the first cell:

    =SUMIF(Sheet3!A:A,A2,Sheet3!B:B)

    And copy down.