Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
I want to get a total (count) of a column of non-numeric characters €“ each
time I use the auto sum feature and select count, the cursor is placed on the first cell of the column waiting for a formula. What am I doing wrong? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
Not sure what you mean but COUNT only counts numbers, try COUNTA
"sdmccabe" wrote: I want to get a total (count) of a column of non-numeric characters €“ each time I use the auto sum feature and select count, the cursor is placed on the first cell of the column waiting for a formula. What am I doing wrong? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
I guess I am saying count the number of cells occupied by characters (not
numbers) in a given column. "daddylonglegs" wrote: Not sure what you mean but COUNT only counts numbers, try COUNTA "sdmccabe" wrote: I want to get a total (count) of a column of non-numeric characters €“ each time I use the auto sum feature and select count, the cursor is placed on the first cell of the column waiting for a formula. What am I doing wrong? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
You can't use the autosum feature in this way. Try this formula
=COUNTA(A1:A6)-COUNT(A1:A6) or =COUNTA(A:A)-COUNT(A:A) (for the whole column) "sdmccabe" wrote: I want to get a total (count) of a column of non-numeric characters €“ each time I use the auto sum feature and select count, the cursor is placed on the first cell of the column waiting for a formula. What am I doing wrong? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
In that case, the counta function is what you want. so, =counta(A:A) will
return the number of cells in coluimn A with characters in them. If you have numbers and letters in a column, and only want to count the number of cells without numbers, then try =counta(A:A)-count(A:A) "sdmccabe" wrote: I guess I am saying count the number of cells occupied by characters (not numbers) in a given column. "daddylonglegs" wrote: Not sure what you mean but COUNT only counts numbers, try COUNTA "sdmccabe" wrote: I want to get a total (count) of a column of non-numeric characters €“ each time I use the auto sum feature and select count, the cursor is placed on the first cell of the column waiting for a formula. What am I doing wrong? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
Perfect, thanks.
"Sloth" wrote: You can't use the autosum feature in this way. Try this formula =COUNTA(A1:A6)-COUNT(A1:A6) or =COUNTA(A:A)-COUNT(A:A) (for the whole column) "sdmccabe" wrote: I want to get a total (count) of a column of non-numeric characters €“ each time I use the auto sum feature and select count, the cursor is placed on the first cell of the column waiting for a formula. What am I doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need formula to count spinoffs | Excel Worksheet Functions | |||
Subtotals by count | Excel Discussion (Misc queries) | |||
Count consecutive dates only | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |