| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
tally of nonblank cells
I have tried to use the =COUNTA( ) function, but when I select the range of
cells to tally, I don't get a number of cells, I get only the function |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
tally of nonblank cells
The cell with the formula in is probably formatted as Text. Use Format
| Cells | Number (tab) to confirm this, and select General or Number with 0 dp. To get Excel to react to this change, double-click the cell (as if to edit it) then click elsewhere. Hope this helps. Pete AustinMom wrote: I have tried to use the =COUNTA( ) function, but when I select the range of cells to tally, I don't get a number of cells, I get only the function |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
tally of nonblank cells
It worked! Thanks so much!
"AustinMom" wrote: I have tried to use the =COUNTA( ) function, but when I select the range of cells to tally, I don't get a number of cells, I get only the function |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
tally of nonblank cells
You're welcome.
Pete AustinMom wrote: It worked! Thanks so much! "AustinMom" wrote: I have tried to use the =COUNTA( ) function, but when I select the range of cells to tally, I don't get a number of cells, I get only the function |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| Adding NonBlank Cells | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Hybrid Mode
