Forum Discussion
Solved
How to determine if there is a non-empty cell in a range
I have tried for over an hour to find a solution to this simple question and finally give up.
ISBLANK(A1:AD3) gave an overflow warning.
Can somebody please tell me the answer?
8 Replies
Thank you.
What are the spaces for? It works well without.
Frank Spade , you are welcome.
Spaces are for better readability, that's up to you use them or not. Doesn't affect calculations.
In Excel in Microsoft 365 and Office 2021, the formula ISBLANK(A1:AD3) returns an array the same size as A1:AD3.
If you just want to know if there is at least one empty cell in the range, you can use
=COUNTIF(A1:AD3,"")>0
This will return TRUE if at least cell is blank, FALSE otherwise.
If you want to know how many cells are blank, use
=COUNTIF(A1:AD3)
- Why not use COUNTBLANK()?
- Thank you.
