Excluding data when using COUNTIF

JennyB.

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.

Kelly P.

@JennyB.

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!

Kelly P.

@JennyB.

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!

JennyB.

Yes, that's exactly what I needed. Thank you