COUNTA()
 

My formula =IF(T2=1/1/2006,"D",IF(T2="","")) displays the D but COUNTA
totals all the formulae and not the values?

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?

COUNTA()
 

Use COUNT(range)-COUNTBLANK(range)

HTH
Kostis Vezerides


Michell Major wrote:
My formula =IF(T2=1/1/2006,"D",IF(T2="","")) displays the D but COUNTA
totals all the formulae and not the values?

COUNTA()
 

If you look at the help for the COUNTA function you'll find that it does
count empty text (""), but not a totally empty cell.
--
David Biddulph

"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?

COUNTA()
 

Thanks so much!!

"Bob Phillips" wrote:

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?

COUNTA()
 

Many Thanks

"vezerid" wrote:

Use COUNT(range)-COUNTBLANK(range)

HTH
Kostis Vezerides


Michell Major wrote:
My formula =IF(T2=1/1/2006,"D",IF(T2="","")) displays the D but COUNTA
totals all the formulae and not the values?