# SUMIF Budget when priority does not equal x

Options
✭✭✭
edited 11/21/23

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!

Tags:

## Best Answers

• ✭✭✭✭✭✭
Answer ✓
Options

Give this a try:

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

• ✭✭✭✭✭✭
Answer ✓
Options

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

• ✭✭✭✭✭✭
Answer ✓
Options

Give this a try:

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

• ✭✭✭
Options

@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?

• ✭✭✭✭✭✭
Answer ✓
Options

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!