Prev: Filter by formula
Next: Count the words in a cell
From: Malcolm on 20 May 2010 12:41
Is it possible to autosum the total of cells that contain only text, in a
worksheet that contains cells with only text and cells with only numbers?
From: T. Valko on 20 May 2010 12:51
Do you mean that you want to *COUNT* cells that contain a specific TEXT
entry?

Try something like this...

=COUNTIF(A2:A100,"Yes")

That will count cells in the range A2:A100 that contain Yes.

--
Biff
Microsoft Excel MVP


"Malcolm" <Malcolm(a)discussions.microsoft.com> wrote in message
news:98256116-B5D1-42EA-A087-D1CD9EA4A591(a)microsoft.com...
> Is it possible to autosum the total of cells that contain only text, in a
> worksheet that contains cells with only text and cells with only numbers?


From: Gord Dibben on 20 May 2010 13:21
=COUNTA(range of cells)-COUNT(range of cells)


Gord Dibben MS Excel MVP


On Thu, 20 May 2010 09:41:01 -0700, Malcolm
<Malcolm(a)discussions.microsoft.com> wrote:

>Is it possible to autosum the total of cells that contain only text, in a
>worksheet that contains cells with only text and cells with only numbers?

 | 
Pages: 1
Prev: Filter by formula
Next: Count the words in a cell