Countif

T

Todd Nelson

When using the countif formula, how can i have it count the cells that have
any text in them?
 
B

bj

if you have a combination of numbers and text in a range

try
=counta(range)-count(range)
 
D

Duke Carey

Array-entered, meaning you commit with Ctrl-Shift-Enter

=SUMPRODUCT(--(ISTEXT(A1:A6)))
 
D

Domenic

Try...

=COUNTIF(A1:A100,"?*")

Note that formula blanks "" are excluded from the count.

Hope this helps!
 
Top