ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   SUM REPHRASED (https://www.excelbanter.com/new-users-excel/186402-sum-rephrased.html)

acp20770

SUM REPHRASED
 
select a cell with a number, then (ctrl) select other cells with numbers...
the sum of the cells should display at the bottom, with each additional cell
that you select... how do i set this up/do this???

Gord Dibben

SUM REPHRASED
 
Right-click on Status Bar and select Sum from the list.

If you don't see the Status Bar, go to ViewStatus Bar.


Gord Dibben MS Excel MVP

On Tue, 6 May 2008 09:54:03 -0700, acp20770
wrote:

select a cell with a number, then (ctrl) select other cells with numbers...
the sum of the cells should display at the bottom, with each additional cell
that you select... how do i set this up/do this???



Gary Brown[_3_]

SUM REPHRASED
 
Sounds like you may have that area set to either 'None'. Right-click on the
bottom bar and a pop-up should appear. The pop-up menu should have a list...
None / Average / Count / Count Nums / Max / Min / Sum
Left-Click on 'Sum'

Hopefully, this will fix your issue.
Sincerely,
Gary Brown


"acp20770" wrote:

select a cell with a number, then (ctrl) select other cells with numbers...
the sum of the cells should display at the bottom, with each additional cell
that you select... how do i set this up/do this???



All times are GMT +1. The time now is 10:54 PM.

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