ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sum of selected cells ? (https://www.excelbanter.com/excel-discussion-misc-queries/124728-sum-selected-cells.html)

Dave H

Sum of selected cells ?
 
Excel normally shows the sum of the selected cells in the lower right hand corner. It has stopped doing so. Is there an option somewhere that turns this off and on, similiar to the manual vs automatic calc option?

Thanks

Peo Sjoblom

Sum of selected cells ?
 
Right click where you normally see it and select sum from the box

Regards,

Peo Sjoblom

Dave H wrote:
Excel normally shows the sum of the selected cells in the lower right
hand corner. It has stopped doing so. Is there an option somewhere
that turns this off and on, similiar to the manual vs automatic calc
option?

Thanks





RagDyeR

Sum of selected cells ?
 
That is ... assuming that the Status Bar is enabled.

Click <View, and make sure there's a check by "Status Bar".
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Peo Sjoblom" wrote in message
...
Right click where you normally see it and select sum from the box

Regards,

Peo Sjoblom

Dave H wrote:
Excel normally shows the sum of the selected cells in the lower right
hand corner. It has stopped doing so. Is there an option somewhere
that turns this off and on, similiar to the manual vs automatic calc
option?

Thanks





All times are GMT +1. The time now is 12:06 PM.

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