Countifs

Wanda Jackson

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?

Genevieve P.

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

Genevieve P.

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

Wanda Jackson

this comes back as unparsonable

Genevieve P.

Hi @Wanda Jackson

Can you post a screen capture of what the formula looks like when it’s in the sheet? (But block out any sensitive data.)

Wanda Jackson

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.

Genevieve P.

Ah yes, column names! I’m glad you figured it out. 🙂