Count if with multiple criteria

freddie

Hi all,

I'm trying to get the count of a specific Call Outcome in a given month.

I've tried =COUNTIF({Call 1 Outcome}, "No Answer") and =COUNTIF({All Calls}, "No Answer") to get the total count however when I add a second condition i.e. =COUNTIF({All Calls}, "No Answer", {All Calls}, "Nov") it given an error.

I'm trying to count a specific outcome for a given month. e.g. total count of 'Follow up' during the month of November.

I'd appreciate any help.

Many thanks,

Faizi

KPH

Hi Freddie

i didn’t pay enough attention to your cross sheet references last night. You need to set up two references with one column in each, not select the whole sheet. Replace the first reference with a reference to just the column containing “no answer”. Replace the second reference with a reference to just the column with the months in.

KPH

Hi @freddie

The COUNTIF function can only evaluate one piece of logic. To include two pieces of logic you can use COUNTIFS. This S in the formula below might be all you need to achieve your aim.

=COUNTIFS({All Calls}, "No Answer", {All Calls}, "Nov")

freddie

Thank you for the help.

I've tried =COUNTIFS({All Calls}, "No Answer", {All Calls}, "Nov") but it returns 0 as the total count instead of the actual count.

KPH

Hi Freddie

i didn’t pay enough attention to your cross sheet references last night. You need to set up two references with one column in each, not select the whole sheet. Replace the first reference with a reference to just the column containing “no answer”. Replace the second reference with a reference to just the column with the months in.

freddie

Thanks much. It worked :)

KPH

Glad I could help!