[SOLVED] Autocalculate with blank cells.

[Rodney]

Good evening all,
apologies, I have had this answered before,
and promptly forgotten.

1. What is the name of the "autocalculate" bar at the bottom?
2. how do I have it include blank cells in "Count"
3. Why, suddenly, my Excel takes 20 seconds or so
to close. (I have turned off "re calculate on exit")

Thank you.

[David McRitchie]

Tell you what if these were answered for you previously
use Google GROUPS Advanced search, placing the
email address that you used at the time as author.
For Groups use: *excel* with the asterisks
http://www.mvps.org/dmcritchie/excel/xlnews.htm
If you use Firefox you see search bar, and my Firefox key word shortcuts
If you use IE you can use the Google searchbar dropdown to get to groups.

Then you can please point to the message-id of where they
were answered for the benefit of others.

The Status Bar on the right side can do SUM and other
calculations, I think this is what you are referring to, since
I have the best (only) write up on it see
http://www.mvps.org/dmcritchie/excel/statusbar.htm

John Walkenbach has decent write-ups on the use of COUNT
so if you don't find your previous answer search his pages
(or find links to his from mine).
Hint you can find link to John's page (tip 52 is one of them) from
http://www.mvps.org/dmcritchie/excel/xlindex.htm

For speed considerations check
http://www.mvps.org/dmcritchie/excel/slowresp.htm
now surely if you had a previous problem, with speed you
would not have forgotten what you did last time. Though it
may not be same problem this time, in which case you'd have to start
over again anyway.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Rodney" <rodney@touch88gum.com.au> wrote in message news:%23XiLeSfiFHA.2472@TK2MSFTNGP15.phx.gbl...
> Good evening all,
> apologies, I have had this answered before,
> and promptly forgotten.
>
> 1. What is the name of the "autocalculate" bar at the bottom?
> 2. how do I have it include blank cells in "Count"
> 3. Why, suddenly, my Excel takes 20 seconds or so
> to close. (I have turned off "re calculate on exit")
>
> Thank you.
>
>
>
>

[Rodney]

Thank you David!
I was feeling definitely unloved there for a while
thought no one was going to answer.
I'll keep your post and work through it.

Here is the bar I was talking about at the bottom of the sheet
I have right clicked it and shown the drop down box
http://cjoint.com/data/hvdjeJUjlg.htm
HTH
and thanks again!

Rodney



--
rodney at touch88.com.au

Send spam to the FTC at
spam@uce.gov
Thanks, robots.



"David McRitchie" <dmcritchie@msn.com> wrote in message news:u$ma4CWjFHA.2444@TK2MSFTNGP10.phx.gbl...
| Tell you what if these were answered for you previously
| use Google GROUPS Advanced search, placing the
| email address that you used at the time as author.
| For Groups use: *excel* with the asterisks
| http://www.mvps.org/dmcritchie/excel/xlnews.htm
| If you use Firefox you see search bar, and my Firefox key word shortcuts
| If you use IE you can use the Google searchbar dropdown to get to groups.
|
| Then you can please point to the message-id of where they
| were answered for the benefit of others.
|
| The Status Bar on the right side can do SUM and other
| calculations, I think this is what you are referring to, since
| I have the best (only) write up on it see
| http://www.mvps.org/dmcritchie/excel/statusbar.htm
|
| John Walkenbach has decent write-ups on the use of COUNT
| so if you don't find your previous answer search his pages
| (or find links to his from mine).
| Hint you can find link to John's page (tip 52 is one of them) from
| http://www.mvps.org/dmcritchie/excel/xlindex.htm
|
| For speed considerations check
| http://www.mvps.org/dmcritchie/excel/slowresp.htm
| now surely if you had a previous problem, with speed you
| would not have forgotten what you did last time. Though it
| may not be same problem this time, in which case you'd have to start
| over again anyway.
| ---
| HTH,
| David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
| My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
| Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
|
| "Rodney" <rodney@touch88gum.com.au> wrote in message news:%23XiLeSfiFHA.2472@TK2MSFTNGP15.phx.gbl...
| > Good evening all,
| > apologies, I have had this answered before,
| > and promptly forgotten.
| >
| > 1. What is the name of the "autocalculate" bar at the bottom?
| > 2. how do I have it include blank cells in "Count"
| > 3. Why, suddenly, my Excel takes 20 seconds or so
| > to close. (I have turned off "re calculate on exit")
| >
| > Thank you.
| >
| >
| >
| >
|
|

[David McRitchie]

yes, is the status bar, as documented on my statusbar.htm page.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Rodney" <rodney@touch88gum.com.au> wrote in message news:ebHgp0YjFHA.3544@TK2MSFTNGP15.phx.gbl...
> Thank you David!
> I was feeling definitely unloved there for a while
> thought no one was going to answer.
> I'll keep your post and work through it.
>
> Here is the bar I was talking about at the bottom of the sheet
> I have right clicked it and shown the drop down box
> http://cjoint.com/data/hvdjeJUjlg.htm
> HTH
> and thanks again!
>
> Rodney
>
>
>
> --
> rodney at touch88.com.au
>
> Send spam to the FTC at
> spam@uce.gov
> Thanks, robots.
>
>
>
> "David McRitchie" <dmcritchie@msn.com> wrote in message news:u$ma4CWjFHA.2444@TK2MSFTNGP10.phx.gbl...
> | Tell you what if these were answered for you previously
> | use Google GROUPS Advanced search, placing the
> | email address that you used at the time as author.
> | For Groups use: *excel* with the asterisks
> | http://www.mvps.org/dmcritchie/excel/xlnews.htm
> | If you use Firefox you see search bar, and my Firefox key word shortcuts
> | If you use IE you can use the Google searchbar dropdown to get to groups.
> |
> | Then you can please point to the message-id of where they
> | were answered for the benefit of others.
> |
> | The Status Bar on the right side can do SUM and other
> | calculations, I think this is what you are referring to, since
> | I have the best (only) write up on it see
> | http://www.mvps.org/dmcritchie/excel/statusbar.htm
> |
> | John Walkenbach has decent write-ups on the use of COUNT
> | so if you don't find your previous answer search his pages
> | (or find links to his from mine).
> | Hint you can find link to John's page (tip 52 is one of them) from
> | http://www.mvps.org/dmcritchie/excel/xlindex.htm
> |
> | For speed considerations check
> | http://www.mvps.org/dmcritchie/excel/slowresp.htm
> | now surely if you had a previous problem, with speed you
> | would not have forgotten what you did last time. Though it
> | may not be same problem this time, in which case you'd have to start
> | over again anyway.
> | ---
> | HTH,
> | David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> | My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> | Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> |
> | "Rodney" <rodney@touch88gum.com.au> wrote in message news:%23XiLeSfiFHA.2472@TK2MSFTNGP15.phx.gbl...
> | > Good evening all,
> | > apologies, I have had this answered before,
> | > and promptly forgotten.
> | >
> | > 1. What is the name of the "autocalculate" bar at the bottom?
> | > 2. how do I have it include blank cells in "Count"
> | > 3. Why, suddenly, my Excel takes 20 seconds or so
> | > to close. (I have turned off "re calculate on exit")
> | >
> | > Thank you.
> | >
> | >
> | >
> | >
> |
> |
>
>