CountIfs

kelsey.beckmeyer
kelsey.beckmeyer ✭✭✭
in Formulas and Functions

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.

Help!?

· Share on FacebookShare on Twitter

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. 


    Thanks  

    Shubham Umale

    Smartsheet Engineer, Ignatiuz Software 

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!