ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Status Bar - SUM function adding grouped cells (https://www.excelbanter.com/excel-discussion-misc-queries/194453-status-bar-sum-function-adding-grouped-cells.html)

slippyslappy

Status Bar - SUM function adding grouped cells
 
I have a set of 5 cells grouped and hidden/collapsed. When I highlight a set
of numbers over these grouped cells, the status bar includes the grouped
cells in the summation...it used to not do this and I want to only sum the
visible numbers.

Do I have a setting is off or something?


All times are GMT +1. The time now is 09:51 PM.

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