google sheets number of filled cells in a column code example Example: number of filled cells google sheets =SUMPRODUCT(LEN(TRIM(A2:A13))>0)