ISBLANK for a range of cells?

Raluca S.

Hello! I'm looking for a formula to either count of show a text when either one of a range of cells are blank. Every time I try to add a range like [Cell 1]@row:[Cell 24]@row it gives me unparseable error. Any advice please?

Much appreciated.

Andrée Starå

Hi @Raluca S.

I hope you're well and safe!

Can you share some screenshots and the formula you're testing? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Raluca S.

@Andrée Starå So, this is the formula that works, but only when I use a single column: =IF(ISBLANK([Project Mgmt]@row), "Blank", "Not blank")

When I want to use an area like this: =IF(ISBLANK([Project Mgmt]25:[Legal]25), "Blank", "Not blank") it tells me #INCORRECT ARGUMENT SET.

Thanks for trying to help.

Paul Newcome

Try doing a count of blank cells.

=IF(COUNTIFS([Project Mgmt]25:[Legal]25, @cell = "")> 0, "Blank", "Not Blank")

The above would show "Blank" if there is at least one blank cell within the range and only shows "Not Blank" when all cells are filled in. The opposite would be showing "Not Blank" if at least one if filled an and only showing "Blank" if all are empty.

=IF(COUNTIFS([Project Mgmt]25:[Legal]25, @cell <> "")> 0, "Not Blank", "Blank")

Raluca S.

Thanks Paul. I tried that but I get #UNPARSEABLE. Is the @cell part meant to be replaced with a specific cell in the sheet?

Paul Newcome

The @cell reference should be left as is. Please double check that I have the column names correct. I just copy/pasted from one of your posts.