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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!