COUNTIF
 

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.

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.