counting rows of text - any text!!

  • Thread starter Thread starter papa
  • Start date Start date
P

papa

Hi guys,

Can anyone help with the following simple query.

What I need to do is get excel to count any row if there
is text in it.

I have a totals page that needs to add the totals of
columns that have any type of text. I need to count
these values as 1.

as in =COUNTIF(F13:x13," ")

what I tried is the wildcard character i.e "*" and "?"
but neither of these seem to work.

What am I doing wrong...

Rgds,
Papa
 
Have you tried the CountA function?

=counta(A1:A20) will give you the number of cells with data in them. This
will include any cells with numbers in them so you may need to also do a
=count() to find how many cells have numbers in them and then minus this
from the number given from the counta function

Hope this helps
JudithJubilee
 
Back
Top