Count if a cell is blank / not blank

aecross

I'm trying to create a formula to help show when tasks are past due.

Basically, I want to count cells where Range 32 is NOT blank (or is a date) and where Range 31 is blank (or is not a date, as it has not been filled in yet).

I don't think this format is correct at all, but I'm struggling on where to go next.

=COUNTIFS(NOT(ISBLANK({Range 32})), AND(ISBLANK({Range 31}))

I appreciate any and all help!

Kleerfyre

Is this formula being used on a different sheet? Are you wanting these to add up? If so, this formula might work:

=COUNTIF({Range 32}, <>" ") + COUNTIF({Range 31}, =" ")

There is a blank space between the quote marks.

aecross

Hi there! I used this formula but am only receiving "0" as an output, when I know that is incorrect. I tried this with a few different ranges and continued to receive 0. Any ideas on how to fix that?

ker9

Hi @aecross

Count only counts non blank values:

Count({Range 32}) + COUNTIF({Range 31}, =" ")

Hope this helps!

Chris_Lloyd

https://community.smartsheet.com/discussion/comment/379265#Comment_379265

This only worked without the blank spaces between "" for me.

Edit to add a Thank You to Kleefrye. Wouldn't have gotten that close w/o this suggestion.