How to count blank cells with no values in Excel ?

What formula should I use, to count all the blank cells in selected range ?
26 Jul 2019 at 07:23 PM
0pnshow more
GillGill
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)
03 Aug 2019 at 06:30 PM
0pnshow more
TimTim
Share on FacebookShare on TwitterShare on LinkedInSend email
Follow us on Facebook & Twitter
2021 AnswerTabsTermsContact us