COUNTIFS Using both AND and OR
Looking for a bit of help trying to utilize the COUNTIFs function to filter based on a specific value for one variable and between two other values for the other variable.
In the sample table below, I'm looking to get a count where the TASTE is PREFERRED and the ALLERGIES is either YES or UNKNOWN.
I've tried the below but am getting an INCORRECT ARGUMENT SET
=SUM(COUNTIFS(Taste:Taste, "Preferred", Allergies:Allergies, "Yes", "Unknown"))
Help Article Resources
Check out the Formula Handbook template!