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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
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.)
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
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. 🙂
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 206 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!