I am trying to create a summary of two columns to see how many of a program type serve a particular population.

Trying: =COUNTIFS([Program Type]:[Program Type]; "Diversion"; [Sub-Pop]:[Sub-Pop]; "Families")

It keeps coming out as unparseable.


Best Answer

  • Shubham
    Shubham ✭✭✭✭
    Answer ✓

    Hi kelsey.beckmeyer

    Hope you are doing well,

    Please use this formula it will help you.

    =COUNTIFS([Program Type]:[Program Type],"Diversion", [Sub-Pop]:[Sub-Pop],"Families")

    I hope this will help you, Have a Good Day. 


    Shubham Umale

    Smartsheet Engineer, Ignatiuz Software 


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!