COUNTIF, ISBLANK, and OR formula

cdvl · 04/17/19

For a particular project category, I'm attempting to count how many times the "Project Status" column is either a blank cell or not "green" (aka complete). These projects will be marked as "Active" on my stats sheet.

Here's the formula that I have thus far and I'm receiving an Invalid Operation error:

=COUNTIFS({CDVL Project Tasklist Range 1}, "Administrative", {CDVL Project Tasklist Range 4}, OR(ISBLANK(@cell), (<>"Green")))

Could someone help me figure this out? Is it even possible to use COUNTSIFS with blank spaces?

Nic Larsen · 04/17/19

Try:

=COUNTIFS({CDVL Project Tasklist Range 1}, "Administrative", {CDVL Project Tasklist Range 4}, OR(ISBLANK(@cell), @cell <>"Green"))

cdvl · 04/18/19

Thank you so much! That worked!

COUNTIF, ISBLANK, and OR formula

Comments

Categories