COUNTIF for Multiple Criteria

Ashton Lahman

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")

John Pudar

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?

Ashton Lahman

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?

John Pudar

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"))

Ashton Lahman

@John Pudar - John, thank you! This was helpful!