COUNTIF

Paul Molloy
✭✭✭✭
Hi
i am trying to count the number of projects "On Hold" and above 0%
=COUNTIF([Install progress]:[Install progress], "On Hold", [% Complete]:[% Complete] > 0)
but this is not working any help?
Answers
-
Change your function to a COUNTIFS with the "S" on the end.
-
Hi Paul
i put =COUNTIFS(([Install progress]:[Install progress], "On Hold", [% Complete]:[% Complete] > 0))
and got #UNPARSABLE
-
You are also missing a comma between your second range and it's criteria:
=COUNTIFS([Install progress]:[Install progress], "On Hold", [% Complete]:[% Complete], > 0)
-
wow thats it ;)
thanks you so much Paul and Leibel :)
have a great weekend
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!