How do I create a formula to capture the total number of inquiries by group name?
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.
Best Answer
-
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)
Answers
-
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)
Help Article Resources
Categories
Check out the Formula Handbook template!