Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculate Bar.
My lower "Calculate Bar" has suddenly began
to give me only a "count" of occupied cells. eg: Count is the same as Count Numbers I'd like it to count vacant cells as well. What might I have done? and how do I get back to my previous Status? Thank you. Rod |
#2
|
|||
|
|||
Hi Rodney,
Apparently it works when there is text or a formula that returns "". Count and Count Num return the same when the cell is empty. Hope this helps. "Rodney" wrote in message ... My lower "Calculate Bar" has suddenly began to give me only a "count" of occupied cells. eg: Count is the same as Count Numbers I'd like it to count vacant cells as well. What might I have done? and how do I get back to my previous Status? Thank you. Rod |
#3
|
|||
|
|||
Thanks John,
that is perplexing, as I am used to it defaulting to count blank cells, I assumed that to be the normal satus. In MSWorks I use =""&"" to fill blank cells for printing vacant cell borders, so I'll try it in Excel. Cheers "JohnS" wrote in message ... | Hi Rodney, | Apparently it works when there is text or a formula that returns "". Count | and Count Num return the same when the cell is empty. | Hope this helps. | "Rodney" wrote in message | ... | My lower "Calculate Bar" has suddenly began | to give me only a "count" of occupied cells. | eg: Count is the same as Count Numbers | I'd like it to count vacant cells as well. | | What might I have done? and how do I get | back to my previous Status? | | Thank you. | Rod | | | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I automatically calculate YTD numbers by changing a date? | Excel Worksheet Functions | |||
How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
Not able to calculate. | Excel Worksheet Functions | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |