| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Text as a Number
I am trying to "Count" a column which has text in it. I'm at a complete
loss. The count and sum formulas ignore text. Can anyone help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Text as a Number
use
=COUNTA() -- Gary''s Student gsnu200703 "Jan from ROF" wrote: I am trying to "Count" a column which has text in it. I'm at a complete loss. The count and sum formulas ignore text. Can anyone help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Text as a Number
Tried this, but the total or count is off...by 5 in both columns
"Gary''s Student" wrote: use =COUNTA() -- Gary''s Student gsnu200703 "Jan from ROF" wrote: I am trying to "Count" a column which has text in it. I'm at a complete loss. The count and sum formulas ignore text. Can anyone help? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Text as a Number
Remember that COUNTA will count cells that APPEAR to be empty if they contain
a formula that is returning an empty string or a cell that contains spaces. COUNTA will also count cells with numbers in them. -- Gary's Student gsnu200703 "Jan from ROF" wrote: Tried this, but the total or count is off...by 5 in both columns "Gary''s Student" wrote: use =COUNTA() -- Gary''s Student gsnu200703 "Jan from ROF" wrote: I am trying to "Count" a column which has text in it. I'm at a complete loss. The count and sum formulas ignore text. Can anyone help? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Text as a Number
Fixed...works....thanks!
"Gary''s Student" wrote: Remember that COUNTA will count cells that APPEAR to be empty if they contain a formula that is returning an empty string or a cell that contains spaces. COUNTA will also count cells with numbers in them. -- Gary's Student gsnu200703 "Jan from ROF" wrote: Tried this, but the total or count is off...by 5 in both columns "Gary''s Student" wrote: use =COUNTA() -- Gary''s Student gsnu200703 "Jan from ROF" wrote: I am trying to "Count" a column which has text in it. I'm at a complete loss. The count and sum formulas ignore text. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| how i change thai text to english text | Excel Worksheet Functions | |||
| Counting the number when you have a number and text | Excel Worksheet Functions | |||
| Change number format from text to number? | New Users to Excel | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
Linear Mode
