Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5
Default 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???
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default 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???


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 6
Default 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???

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"