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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    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)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!