Forum Discussion

Traffic Safety Solutions's avatar
Traffic Safety Solutions
Copper Contributor
Apr 05, 2018

=countblank function with an inconsistent range

Can I use the COUNTBLANK function to count empty cells in an inconsistent range. =countblank(A1,A3,A5) does not work.   Is there another way?   =sum(countblank(A1),countblank(A2),countblank(A...
Formulas & Functions
Need Help
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 05, 2018

John,

 

may be:

=3-COUNTA(A1,A3,A5)

Resources