COUNTIFS with multiple criteria
Hello,
I am a newer Smartsheet user and am learning as I go. I have tried several times to use COUNTIFS functions to count specific criteria from 2 columns in my source sheet, but continue to get the UNPARSEABLE error. (I also tried COUNTIF, then CONTAINS, but could not get that to work either.
We are wanting to count how many "General Applicants" in the Provider Type column also have "Founded" in the Disposition column.
This is the most recent formula I have tried with no luck: =COUNTIFS({8.31.22_Data_ProjectRollup Range 2}, "General Applicant"), COUNTIFS({8.31.22_Data_ProjectRollup Range 3}, "Founded")
Thanks for any help/suggestions you can give me!
Best Answer
-
=COUNTIFS({8.31.22_Data_ProjectRollup Range 2}, "General Applicant", {8.31.22_Data_ProjectRollup Range 3}, "Founded")
Answers
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!