CountIfs
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!?
Best Answer
-
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
Answers
-
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
-
Yes! Thank you!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!