One way

=SUMPRODUCT(--(A1:A1000<" "),--(LEN(A1:A1000)0))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DougMc" wrote in message
...
How can I ignore a blank cell (spacebar pressed) when using COUNTA. I
want
to count cells with valid data where a spacebar press in invalid. A blank
cell is valid (so is not counted)