MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Countif


Posted by Brian on January 28, 2002 6:35 PM

What criteria can I use to count any text or numbers?
By text I mean any cell with text as data, or any cell that has a number in it.

Brian


Posted by Paul on January 28, 2002 7:04 PM

=CountA() Will count cells with numbers or text as in =COUNTA(A1:A6) (NT)

Posted by Brian on January 28, 2002 7:27 PM

Thanks Paul!

Posted by Mark W. on January 28, 2002 8:04 PM

Posted by Mark W. on January 28, 2002 8:11 PM


This website doesn't like a less than
character followed by another non-space
character. My last posting had such a text
string. So I'll here's an attempt at a
repost...

You can also use =COUNTIF(A1:A6,"< >") where
"< >" represents a 2-character text string
consisting of < followed by > . : What criteria can I use to count any text or numbers?


Posted by Brian on January 28, 2002 9:13 PM

Thanks Mark!!!