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

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.

Answers

  • Paul NewcomePaul 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)

Sign In or Register to comment.