ExcelBanter - I need formula that will automatically count the filled cells.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I need formula that will automatically count the filled cells. (https://www.excelbanter.com/excel-discussion-misc-queries/55452-i-need-formula-will-automatically-count-filled-cells.html)

Benar_Isais

I need formula that will automatically count the filled cells.

I need formula that will automatically count the filled cells.

Biff

I need formula that will automatically count the filled cells.

Hi!

One way:

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

Biff

"Benar_Isais" wrote in message
...
I need formula that will automatically count the filled cells.

topola

I need formula that will automatically count the filled cells.

I think =COUNTA() would make it.

All times are GMT +1. The time now is 05:00 AM.