Forum Discussion

Erik Stearns's avatar
Erik Stearns
Copper Contributor
Jun 08, 2025

Problems with a SUMIFS formula

I'm really having some trouble with Excel in that it's not behaving logically.  Essentially, what I'm trying to do is conditional sums for spending categorizations.  But

when I use the formula, I get an error that I can't figure out, because when I use the Function Wizard, it seems to work nicely.  But yet, it comes up with this error, and I can't find any information sufficient enough to solve this.  

Here is the formula:

=SUMIFS(B2+H4:H15,H4:H15,"Netspend Account",C2,"Netspend Account")

Resources