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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!