COUNTIF, ISBLANK, and OR formula
Options
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?