COUNTIFS not working correctly with dropdown critierion


I am using the following formula to count the number of rows that have both [Pricing] unchecked and [Status] showing any other value EXCEPT "Not Applicable.

=COUNTIFS(Pricing:Pricing, 0, Status:Status, <>"Not Applicable")

When I use the above formula, it keeps showing the incorrect value.

I've filtered the sheet using the same criteria (Pricing is unchecked and Status is not one of "Not Applicable") and it manages to show the correct value.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!