COUNT functions

J

Jeri

I'm trying to count text and dates within a range. Is
there a way to combine the COUNT and COUNTA or COUNTIF
functions? Any suggestions? Thanks
 
J

Jason Morin

COUNT will count all dates since dates are just numerical
values in Excel.

=COUNTIF(A1:A10,"*")

will count all text.

HTH
Jason
Atlanta, GA
 
Top