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

  • Kelly P.
    Kelly P. ✭✭✭✭✭✭
    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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!