SUMIFS does not work with formulas

[Elva_Tanguerre]

Hello, I have a SUMIFS formula that returns "0", probably because the columns it is based on are either formulas themselves or a pivot report:

=SUMIFS(A:A,C:C,"pledge",B:B,E4)

The SUMIFS is in the "pledged" column in yellow. Thanks.

[#2 · Accepted solution]

@Elva_Tanguerre 

I'd check in any empty cell

=C4="Pledge"

=B4=E4

That could be extra spaces on non-printable characters somewhere.

[#3]

Hi Sergei, there was indeed an error - I mispelled "pledge" - the value was "pledges" DUH!! I was able to find this because of the simple check formulas you suggested. Never though of it. Thanks!!

[#4]

@Elva_Tanguerre , glad to know it helped