Cross sheet count if.

Options

Looking to count from a contact column the number of times a name appears for any one month and year. The below resulting in #unparseable, a variation of resulted in #Invalid Argument set?

=COUNTIFS({Completed Dispatches Range 1}, AND(IFERROR(YEAR(@cell), 0) = 2023, IFERROR(MONTH(@cell), 0) = Category@row)) > 0, COUNTIFS({Completed Dispatches Range 1}, AND(IFERROR(YEAR(@cell), 0) = 2023, IFERROR(MONTH(@cell), 0) = Category@row, {Completed Dispatches Range 2}, CONTAINS("jason", @cell))))

Regards

Cheers.

Forever forwards Backwards never.

Best Answer

  • Jason P
    Jason P ✭✭✭✭
    Answer ✓
    Options

    Worked it...

    =COUNTIFS({Completed Dispatches Range 3}, CONTAINS("Jason", @cell), {Completed Dispatches Range 2}, IFERROR(MONTH(@cell), 0) = Category@row, {Completed Dispatches Range 2}, AND(IFERROR(YEAR(@cell), 0) = 2023))

    Cheers.

    Forever forwards Backwards never.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!