Countifs

Options

I have a column that has 3 different entries for each row and I need to count each of them in the column. How do I use Countifs for this task? I keep getting either Unparsonable or Incorrect Argument Set


=COUNTIFS([Event Type]6:[Event Type]941, "Tag 1", [Event Type]6:[Event Type]941, "Tag 2", [Event Type]6:[Event Type]941, "Tag 3")

This renders a count of "0" (wrong count)

=COUNTIFS([Event Type]:[Event Type], "Tag 1", [Event Type]:[Event Type], "Tag 2", [Event Type]:[Event Type], "Tag 3")))

This renders 'unparsonable'


=COUNTIF([Event Type]:[Event Type], "Tag 1", COUNTIF([Event Type]:[Event Type], "Tag 2"", COUNTIF([Event Type]:[Event Type], "Tag 3")))

This renders 'incorrect argument set'

Can anyone help with this?

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓
    Options

    Hi @Wanda Jackson

    Try adding your three separate counts together with +, instead!

    =COUNTIF([Event Type]:[Event Type], "Tag 1") + COUNTIF([Event Type]:[Event Type], "Tag 2") + COUNTIF([Event Type]:[Event Type], "Tag 3")

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!