SUMIF Budget when priority does not equal x

Angela.R ✭✭✭
edited 11/21/23 in Formulas and Functions

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!