On status bar, sum of selected cells doesn't automatically appear.
 

Excel 2003 -
when you use the auto filter - nomally the sum of cells selected
automatically shows up on the bottom left hand side of the status bar - eg:
32 of 100 records found..
but this is not always the case when i open or start a new worksheet
Can anyone tell me if there is a function to activeate this on my
worksheet...
thanx

On status bar, sum of selected cells doesn't automatically appear.
 

Debra Dalgleish explains why and offers some workarounds:
http://contextures.com/xlautofilter02.html#Count

Chozzie wrote:

Excel 2003 -
when you use the auto filter - nomally the sum of cells selected
automatically shows up on the bottom left hand side of the status bar - eg:
32 of 100 records found..
but this is not always the case when i open or start a new worksheet
Can anyone tell me if there is a function to activeate this on my
worksheet...
thanx

--

Dave Peterson

On status bar, sum of selected cells doesn't automatically appear.
 

Right click on status bar, and see is sum or some other function selected.


"Chozzie" wrote in message
...
Excel 2003 -
when you use the auto filter - nomally the sum of cells selected
automatically shows up on the bottom left hand side of the status bar -
eg:
32 of 100 records found..
but this is not always the case when i open or start a new worksheet
Can anyone tell me if there is a function to activeate this on my
worksheet...
thanx