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(A3)) works but is clumsy. 

 

Thanks

 

John Bruno

Formulas & Functions
Need Help
  • Jamil's avatar
    Jamil
    Bronze Contributor
    Apr 06, 2018

    this =SUM(COUNTBLANK(INDIRECT({"A1","A3","A5"})))

     

    or with COUNTIF 

    =SUMPRODUCT(COUNTIF(INDIRECT({"A1","A3","A5"}),""))

Resources