COUNTIFS not working correctly with dropdown critierion

Joe D

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.

Paul Newcome

Try this:

=COUNTIFS(Pricing:Pricing, @cell <> 1, Status:Status, <>"Not Applicable")

Joe D

I pasted in that formula and it still didn't work. Does it matter of some of the Status fields are blank?

Paul Newcome

Would you want the blanks included or excluded from the count?