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 |