ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   filters and summing in status bar (https://www.excelbanter.com/excel-discussion-misc-queries/156458-filters-summing-status-bar.html)

ann

filters and summing in status bar
 
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.

Gord Dibben

filters and summing in status bar
 
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

On Thu, 30 Aug 2007 10:02:04 -0700, Ann wrote:

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.




All times are GMT +1. The time now is 12:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com