Are these dates that are numeric? If so use COUNT instead of counta,
otherwise you can use

=COUNTIF(A:A,"*?" )

to count text but not ""


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com




"martins" wrote in
message ...

I am using COUNTA to count data in a range of cells - the data in this
instance is dates formatted as say Jan-06 - should work ok except that
the formula is also counting cells which maybe blank but contain other
formulas - what do I need to do to just return a result for the data as
specified?


--
martins
------------------------------------------------------------------------
martins's Profile:
http://www.excelforum.com/member.php...o&userid=31616
View this thread: http://www.excelforum.com/showthread...hreadid=529414