You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

PuddleOfFat Author

Level 1

5 points

How to find blank cells in a range?

How can I find blank cells in a range, particularly if I am trying to look down a column for blanks in that column? I don’t care to know the position (if it’s it possible), I only care to know if there are blanks at all.

The “ISBLANK” formula only works for a single cell/value, not a range.

[This question is related to my other question, but I felt it was different enough that it deserved its own post for clarity. You can view my other post/question by clicking here.]

Posted on Jun 15, 2023 10:41 AM

Top-ranking reply

Barry

Level 9

59,951 points

Posted on Jun 15, 2023 1:27 PM

HI PoF,

Here's one way:

The formula shown below the table is entered in cell B1, but could be placed elsewhere.

Column C shows a variation on the method.

C2 to C18 contain this formula: LEN(B2)<1

which checks the cell(s) in the same row of column B for 'no content', and returns true if there is nothing taking space in that cell.

C1 contains the same formula as B1, (shown above), with the arguments changed to count the 'true's in column C:

COUNTIF(C2:C18,true)

Regards,

Barry

View in context

How to find blank cells in a range?

Similar questions