Try in say, B1: =COUNTA(A:A)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Gary T wrote in message
...
Hi,
I want to count the number of entries in column A. Formula is to count
all
cells that have data in them. Cells could theoretically contain a
numerical
"0" (i.e. cost=£0), which I want ot be included in the COUNTIF function.
Only blanks (i.e. tested by an IF(A3="".... etc) are not to count.
Many Thanks,
Gary.
|