Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using the "count" function..
I wanted to use the "count" function to total a column of account numbers. I
used =Count(A9:A188) but the result is "0". Am I not using the correct function? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using the "count" function..
Mary
Try COUNTA which counts 'non empty' cells in the range, rather than cells with just numbers, as your account 'numbers' may not be, or be seen as such by Excel -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Mary A Perez" wrote in message ... I wanted to use the "count" function to total a column of account numbers. I used =Count(A9:A188) but the result is "0". Am I not using the correct function? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using the "count" function..
If you are trying to calcullate the count of Account Numbers and those
account numbers are text, not numeric, cells...use the COUNTA function. (the COUNT function only counts numeric cells) Does that help? *********** Regards, Ron XL2002, WinXP "Mary A Perez" wrote: I wanted to use the "count" function to total a column of account numbers. I used =Count(A9:A188) but the result is "0". Am I not using the correct function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |