Countif
 

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

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

try
=counta(range)-count(range)
"Todd Nelson" wrote:

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

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

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

"Todd Nelson" wrote:

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

Try...

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

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

Hope this helps!

In article ,
"Todd Nelson" wrote:

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

No need to array-enter. Simple entry will work fine.
Bob Umlas
Excel MVP

"Duke Carey" wrote in message
...
Array-entered, meaning you commit with Ctrl-Shift-Enter

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

"Todd Nelson" wrote:

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