COUNTA()
Use
=COUNTIF(X:X,"D")
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Michell Major" wrote in message
...
My formula =IF(T2=1/1/2006,"D",IF(T2="","")) displays the D but COUNTA
totals all the formulae and not the values?
|