filters and summing in status bar

G

Guest

when i filter on anything, it doesn't show me the sum of the totals in the
status bar. how do i get this to show me.
 
G

Gord Dibben

First you must right-click on the status bar and check the Sum function.

Second you must select the filtered data.


Gord Dibben MS Excel MVP
 

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

Notepad status bar missing even after Registry entry 0
Staus Bar - Size Matters 1
formula results in the status bar 3
I can't see totals in status bar when I highlight cells 3
Auto Filter Summary in Status Bar 1
Cant use sum function or status bar 1
Status Bar not showing statistics 2
Status Bar formatting 1

Top