How do I create a formula to capture the total number of inquiries by group name?

Beronica Muller

I am trying to create a formula to capture the total number of inquiries by plan group name?  I can use the formula =COUNTIFS({National Alliance Operation Inquiries Range 2}, "GROUP NAME", however, I have over 200 groups to choose from. I am not sure how I can capture them without creating a formula for each plan group name.

Paul Newcome

If you put the plan group names in a column

GROUP NAME Formula

Group A.........................f

Group B.........................f

Group C.........................f

etc

You can use a cell reference.

=COUNTIFS({National Alliance Operation Inquiries Range 2}, [Group Name]@row)

Paul Newcome

If you put the plan group names in a column

GROUP NAME Formula

Group A.........................f

Group B.........................f

Group C.........................f

etc

You can use a cell reference.

=COUNTIFS({National Alliance Operation Inquiries Range 2}, [Group Name]@row)