SUMIF Budget when priority does not equal x

Angela.R

I've tried to review this older post (among others) to see if I could figure out why my formula was not working. But was unable to sort out why.

SUMIF - all options EXCEPT one (NOT function?)

Sarah Bird

Oct 9, 2020

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!

---

View Post

Trying to SUM a budget column if the Priority column does NOT equal "N/O"

=SUMIF([Priority]:[Priority] <> "N/O"), [Budget]:[Budget])

=SUMIF([Budget]:[Budget], Priority:Priority <> "N/O"))

Not understanding what i'm doing wrong. Thanks in advance community!

Carson Penticuff

Give this a try:

=SUMIF([Priority]:[Priority], @cell <> "N/O", [Budget]:[Budget])

Carson Penticuff

That is an odd quirk I have not noticed previously. It appears Smartsheet does not consider blank cells using this syntax. I just tested this and it seems to work.

=SUMIF(Priority:Priority, NOT(@cell = "N/O"), Budget:Budget)

Carson Penticuff

Give this a try:

=SUMIF([Priority]:[Priority], @cell <> "N/O", [Budget]:[Budget])

Angela.R

@Carson Penticuff , attn anyone - I noticed it is NOT counting if Priority column is blank. (Which i want it to sum based on all criteria; except if Priority equals "N/O") sum budget when priority column is blank i want to allow. how do i adjust the formula?

Carson Penticuff

That is an odd quirk I have not noticed previously. It appears Smartsheet does not consider blank cells using this syntax. I just tested this and it seems to work.

=SUMIF(Priority:Priority, NOT(@cell = "N/O"), Budget:Budget)