hi,

one solution maybe

=COUNTBLANK(A1:A16)+COUNTA(A2:A16)
change range to suit
steve