COUNTIF for Multiple Criteria
Hello,
I'm trying to use the COUNTIF function to pull a total number from three different columns. Each total would need to include the criteria word for the three columns to be counted. The formula works until I add the third criteria and then it takes the total down to 0. I'm not getting an error, however. Can someone provide insight on what I'm doing wrong? Should I have an AND in there somewhere?
=COUNTIFS({Campaign Request Intake Range 1}, "Email", {Campaign Request Intake Range 4}, "LATAM", {Campaign Request Intake Range 5}, "Paula")
Answers
-
Hi @Ashton Lahman - I'm not seeing anything wrong with the syntax of your formula. Is it possible that the third criterion ("Paula" in this case) is somehow entered differently in your source sheet, or that no lines meet the three criteria specified in the formula?
-
The criterion have multi-select options. It isn't counting those. How would the formula change to ensure the key word is picked up when multiple selections are in a cell? Would the HAS function need added in there?
-
Hi @Ashton Lahman -- Ah, that might do it... Try this:
=COUNTIFS({Campaign Request Intake Range 1}, "Email", {Campaign Request Intake Range 4}, "LATAM", {Campaign Request Intake Range 5}, HAS(@cell, "Paula"))
-
@John Pudar - John, thank you! This was helpful!
Help Article Resources
Categories
Check out the Formula Handbook template!