|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 20th, 2010, 05:41 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? 
|
|
#2
May 20th, 2010, 05:51 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?
|
|
#3
May 20th, 2010, 06:21 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
