Not possible without VBA

You can install Harlan Grove's function EXTCELL

ftp://members.aol.com/hrlngrv/ExtCell.zip

--
Regards,

Peo Sjoblom


"Troy" wrote in message
...
I wish to use countif using cell/text format criteria as opposed to
number/data criteria?