ExcelBanter - Totaling text cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Totaling text cells (https://www.excelbanter.com/excel-worksheet-functions/264215-totaling-text-cells.html)

malcolm

Totaling text cells

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?

T. Valko

Totaling text cells

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" wrote in message
...
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?

Gord Dibben

Totaling text cells

=COUNTA(range of cells)-COUNT(range of cells)

Gord Dibben MS Excel MVP

On Thu, 20 May 2010 09:41:01 -0700, Malcolm
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?

All times are GMT +1. The time now is 08:34 AM.