How do I count multiple types in a column?

nicoleejordannn

This is my current formula that works:

=COUNTIFS({STATUS}, "Completed", {AUDIENCE CATEGORY}, HAS(@cell, "All Employees"), {QUARTER}, HAS(@cell, "Q1'23"))

But now, I need the formula to count multiple quarters (see the last part of the equation). I need it to pull Q1'23, Q2'23, Q3'23, Q4'23. How do I add those on? ...

Thank you!

Ryan Sides

Hi @nicoleejordannn If your Quarter column has various values, you'll need the OR operator to check to see if QUARTER has "Q1'23" or "Q2'23" or...

=COUNTIFS({STATUS}, "Completed", {AUDIENCE CATEGORY}, HAS(@cell, "All Employees"), {Quarters}, OR(HAS(@cell, "Q1'23"), HAS(@cell, "Q2'23"), HAS(@cell, "Q3'23"), HAS(@cell, "Q4'23")))

Is your Quarters column a multi select dropdown? If so, the above will work. If it isn't, let me know.

@A Rose your suggestion would work, but it would add the requirement of all quarters to exist in the row before that row would be counted.

A Rose

Hi @nicoleejordannn,

Can you add after: {QUARTER}, HAS(@cell, "Q1'23"), {QUARTER}, HAS(@cell, "Q2'23") etc. ?

Thank you,

Ryan Sides

Hi @nicoleejordannn If your Quarter column has various values, you'll need the OR operator to check to see if QUARTER has "Q1'23" or "Q2'23" or...

=COUNTIFS({STATUS}, "Completed", {AUDIENCE CATEGORY}, HAS(@cell, "All Employees"), {Quarters}, OR(HAS(@cell, "Q1'23"), HAS(@cell, "Q2'23"), HAS(@cell, "Q3'23"), HAS(@cell, "Q4'23")))

Is your Quarters column a multi select dropdown? If so, the above will work. If it isn't, let me know.

@A Rose your suggestion would work, but it would add the requirement of all quarters to exist in the row before that row would be counted.

nicoleejordannn

@Ryan Sides I didn't have the quarters in the dropdown but added it and it worked perfectly. Thank you so much!

Ryan Sides

@nicoleejordannn Glad to hear it!