COUNTIF, ISBLANK, and OR formula

cdvl

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

Try: 

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

cdvl

Thank you so much! That worked!