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 in the "pledged" column in yellow. Thanks.
I'd check in any empty cell
=C4="Pledge"
=B4=E4
That could be extra spaces on non-printable characters somewhere.
3 Replies
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
