以欄號 計整欄多少數字 (14532)

AE2{=COUNT(0/OFFSET(A$1,,MATCH(1=1,ADDRESS(1,ROW($1:$99),4)=AD2&1,)-1,19))

另解=COUNT(INDIRECT(AD2&":"&AD2))

另解{=COUNT(0/OFFSET(A$1,,MAX(COLUMN(INDIRECT(AD2&1))-1),99))