Countifs

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
-
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
Answers
-
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
-
this comes back as unparsonable
-
Can you post a screen capture of what the formula looks like when it’s in the sheet? (But block out any sensitive data.)
-
Genevieve, after re-naming my columns, the formula worked. The column names had parenthesis included included with the title - ex. Tag (1), etc. These extra parenthesis may have been causing the error in the formula.
Thank you for your help with this.
-
Ah yes, column names! I’m glad you figured it out. 🙂
Help Article Resources
Categories
Check out the Formula Handbook template!