I need formula that will automatically count the filled cells.
I need formula that will automatically count the filled cells.
Hi!
One way:
=SUMPRODUCT(--(LEN(A1:A10)>0))
Biff
"Benar_Isais" <[email protected]> wrote in message
news:[email protected]...
>I need formula that will automatically count the filled cells.
I think =COUNTA() would make it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks