I can't see totals in status bar when I highlight cells

C

Crnhskr

When using the Filter function, or when simply highlighting a range of
numeric cells, I don't see the row count or sum in the status bar at the
bottom. Previously when using filter, you would see 15 of 70 rows, or
something like that. Now I don't see anything.
 
G

Gary''s Student

Select a pile of numeric cell and then right-click the status bar and select
Sum (its at the bottom of the list)
 
S

Shane Devenshire

Hi,

This feature does not always work. Also, VBA code can overwrite this area
with other content of blank.

But that feature is entirely different from the SUM and COUNT info, those
refer to any selected range and have nothing to do with the Filter.

For make sure your Status bar is displayed (2003) choose View, Status Bar.
In 2007 right click the Status bar and turn on the options you want. (this
won't effect the 15 or 70 records found message).
 
A

apache mono

Then i realized that I am trying to add non numeric value...i.e, total count of X.. so i right click on status bar and changed sum to count and got this resolved. try this



Shane Devenshire wrote:

Hi,This feature does not always work.
07-Jan-09

Hi,

This feature does not always work. Also, VBA code can overwrite this area
with other content of blank.

But that feature is entirely different from the SUM and COUNT info, those
refer to any selected range and have nothing to do with the Filter.

For make sure your Status bar is displayed (2003) choose View, Status Bar.
In 2007 right click the Status bar and turn on the options you want. (this
won't effect the 15 or 70 records found message).

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


Previous Posts In This Thread:

I can't see totals in status bar when I highlight cells
When using the Filter function, or when simply highlighting a range of
numeric cells, I don't see the row count or sum in the status bar at the
bottom. Previously when using filter, you would see 15 of 70 rows, or
something like that. Now I don't see anything.

Select a pile of numeric cell and then right-click the status bar and select
Select a pile of numeric cell and then right-click the status bar and select
Sum (its at the bottom of the list)
--
Gary''s Student - gsnu200824


:

Hi,This feature does not always work.
Hi,

This feature does not always work. Also, VBA code can overwrite this area
with other content of blank.

But that feature is entirely different from the SUM and COUNT info, those
refer to any selected range and have nothing to do with the Filter.

For make sure your Status bar is displayed (2003) choose View, Status Bar.
In 2007 right click the Status bar and turn on the options you want. (this
won't effect the 15 or 70 records found message).

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire



Submitted via EggHeadCafe - Software Developer Portal of Choice
SQL Server OLEDB DSNLess connection string sample
http://www.eggheadcafe.com/tutorial...57-24b339db72ea/sql-server-oledb-dsnless.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Issue with "Average" showing in Status Bar 2
Status Bar not showing statistics 2
Cumulative formula for word table 0
How do I add cells by highlighting them? 2
filters and summing in status bar 1
Status Bar - SUM function adding grouped cells 0
Cannot bring rows to Height 1 in Print view 0
formula results in the status bar 3

Top