| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why does "=counta(d9:d44)" return "37"
Just wondering why when I use the COUNTA function in my spreadsheet it
returns a value that is one more than actual answer. This new math is driving me crazy. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why does "=counta(d9:d44)" return "37"
counta counts text and numbers. Maybe you're looking for count? Or maybe
one of your cells which you think is not formatted as text is formatted as text. -- Brevity is the soul of wit. "imfletcher" wrote: Just wondering why when I use the COUNTA function in my spreadsheet it returns a value that is one more than actual answer. This new math is driving me crazy. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why does "=counta(d9:d44)" return "37"
Are you sure that you formula is *exactly*:
=COUNTA(D9:D44) ? Both of these will return 37: =COUNTA(D9:D44,) =COUNTA(,D9:D44) -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "imfletcher" wrote in message ... Just wondering why when I use the COUNTA function in my spreadsheet it returns a value that is one more than actual answer. This new math is driving me crazy. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
| help with index to return particular cell value | Excel Discussion (Misc queries) | |||
| annualized return calculation for the purpose of portfolio performance evaluation | Excel Worksheet Functions | |||
| check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
| How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
Hybrid Mode
