SUMIFS for Not Equal (<>)

I have a SUMIFS formula that works:

=SUMIFS({GLData Range 1}, {GLData Range 6}, (@cell = "RES602835"))

I need to add a bit that would look at another column (let's call it GLData Range X) and pull in results that don't equal "turkey".

I've tried using <> as well as NOT but can't seem to get it to work. I wind up with a result of 0 which is not correct.

Thanks.

Best Answer

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!