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.

https://community.smartsheet.com/discussion/72082/sumif-all-options-except-one-not-function

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)