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!!!
