Count if with multiple criteria

Options

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


Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓
    Options

    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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!