# Count if with multiple criteria

✭✭

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

• ✭✭✭✭✭✭

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.

• ✭✭✭✭✭✭

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

• ✭✭

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.

• ✭✭✭✭✭✭

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.

• ✭✭

Thanks much. It worked :)

• ✭✭✭✭✭✭