I need formula that will automatically count the filled cells.

[Benar_Isais]

I need formula that will automatically count the filled cells.

 

[Biff]

Hi!

One way:

=SUMPRODUCT(--(LEN(A1:A10)>0))

Biff

 

[topola]

I think =COUNTA() would make it.