Forum Discussion
Solved
SUMIFS does not work with formulas
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 i...
I'd check in any empty cell
=C4="Pledge"
=B4=E4
That could be extra spaces on non-printable characters somewhere.
I'd check in any empty cell
=C4="Pledge"
=B4=E4
That could be extra spaces on non-printable characters somewhere.
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!!
Elva_Tanguerre , glad to know it helped