SUMIF Budget when priority does not equal x
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.
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!
Best Answers
-
Give this a try:
=SUMIF([Priority]:[Priority], @cell <> "N/O", [Budget]:[Budget])
-
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)
Answers
-
Give this a try:
=SUMIF([Priority]:[Priority], @cell <> "N/O", [Budget]:[Budget])
-
@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?
-
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)
Help Article Resources
Categories
Check out the Formula Handbook template!
