detect a filled out cell

  • Thread starter Thread starter Alain R.
  • Start date Start date
A

Alain R.

Hi,

I would like to check a column.
If a cell has text, i want to increase a counter.
could it be done using SUMIF ?

something like SUMIF(Page1!A:A;cell <>"";total=total+1)

i don't want to use VBA
thanks,
Alain
 
Hi Alain,

=COUNTIF(A:A,"<>")

It will count all non-empty cells, also numbers

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top