SUMIF - all options EXCEPT one (NOT function?)


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
    David Tutwiler Overachievers Alumni

    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"