Excluding data when using COUNTIF
Hi, I have a graph on a dashboard based on the status of a project using the following formula for each status:
=COUNTIF({Optimisation List Range 2}, "Unallocated")
We do not want to pull through any project that is on hold but want to keep the status as it is on this column so have an additional column with the RAG Status which will include 'on hold'. How do I omit these from the count?
Any advice would be greatly appreciated.
Best Answer
-
If I'm understanding your question correctly, you want to counts from one column but want to exclude projects that have an "On Hold" status in a second column. If so, then a countifs formula would work:
=COUNTIFS({Column to Count}, "Unallocated", {Other column}, <>"On Hold")
Hope this helps!
Answers
-
If I'm understanding your question correctly, you want to counts from one column but want to exclude projects that have an "On Hold" status in a second column. If so, then a countifs formula would work:
=COUNTIFS({Column to Count}, "Unallocated", {Other column}, <>"On Hold")
Hope this helps!
-
Yes, that's exactly what I needed. Thank you
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 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!