Forum Discussion
=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...
this =SUM(COUNTBLANK(INDIRECT({"A1","A3","A5"})))
or with COUNTIF
=SUMPRODUCT(COUNTIF(INDIRECT({"A1","A3","A5"}),""))