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.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!