=IF(LEN(A2)=0,"",SUMPRODUCT((LEN(A$2:A2)>0)*1))

=IF(LEN(A2)=0,"なし",SUMPRODUCT((LEN(A$2:A2)>0)*1))

=IF(A2="","",SUMPRODUCT((A$2:A2<>"")*1))
