How to count blank cells with no values in Excel ? | |||||||||||
What formula should I use, to count all the blank cells in selected range ? | |||||||||||
| |||||||||||
Hi, To count the number of blank cells in a range, you can use COUNTIF or COUNTBLANK. For example: =COUNTIF(A2:A7,"") =COUNTBLANK(A2:A7) | |||||||||||
| |||||||||||
| |||||||||||
![]() ![]() ![]() ![]() | |||||||||||
2022 AnswerTabs | Terms | Contact us |