I'm trying to count how many blank spaces there are in a given column. However, whenever I put in the below formula, it just gives me the total amount of rows in the column, but the entire column is not blank:
=COUNTIFS({CDVL Project Tasklist Range 4}, "")
I've also tried this formula, but to the same results:
=COUNTIFS({CDVL Project Tasklist Range 4}, ISBLANK(@cell))
What am I missing?
EDIT: I've included a screenshot of the data with names blacked out. As you can see, what I have labeled at CDVL Project Tasklist Range 4 does have data in it. Some previous formulas I've used for the range include =COUNTIFS({CDVL Project Tasklist Range 4}, "Blue"), =COUNTIFS({CDVL Project Tasklist Range 4}, "Yellow"), etc. corresponding to the status color, and they've all worked. I have no clue way the BLANK formula is not working.
