Thread: Countif
View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default

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?