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

[Guest]

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]

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

 

[Mladen_Dj]

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