SUMIF - all options EXCEPT one (NOT function?)

Sarah Bird

Hello,

I am having some issues trying to create a formula to sum all the values in the column (called Scheduled Anode(s)), except for rows where a status column reads "No action required".

This was my best attempt, but it doesn't give the result I want, it sums to 0 instead of the 40 or so value it should be.

=SUMIF([Status]:[Status], NOT(Status@row="No Action Required"), [Scheduled Anode(s)]:[Scheduled Anode(s)])

Any suggestions appreciated!

David Tutwiler

I think SumIfs will do the trick:

I think the problem is introducing the range again in the NOT statement. I think what you're looking for is just:

=SUMIF([Status]:[Status], <>"No Action Required"), [Scheduled Anode(s)]:[Scheduled Anode(s)])

where <> is "not equal to"