M
Michell Major
My formula =IF(T2>=1/1/2006,"D",IF(T2="","")) displays the D but COUNTA
totals all the formulae and not the values?
totals all the formulae and not the values?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
Use
=COUNTIF(X:X,"D")
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
=COUNTIF(X:X,"D")
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
V
vezerid
Use COUNT(range)-COUNTBLANK(range)
HTH
Kostis Vezerides
HTH
Kostis Vezerides
D
David Biddulph
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.
count empty text (""), but not a totally empty cell.
M
Michell Major
Thanks so much!!
Bob Phillips said:Use
=COUNTIF(X:X,"D")
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
M
Michell Major
Many Thanks
vezerid said:Use COUNT(range)-COUNTBLANK(range)
HTH
Kostis Vezerides