Try in say, B1: =COUNTA(A:A)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Jim" wrote in message
...
how do I write a count if formula to could a range of cells that can have
any
data. For example if I want to count cell a1:a6 only if the cells have
some
kind of data (numbers, letters, words, etc...)? Thanks for the help.