#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 80
Default calculate on the fly

hey all,
isn't there a way to select the a group of cells that contain numbers and
have it automatically show the sum on the status bar?

thanks,
rodchar
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default calculate on the fly

Right click on Status Bar and tick SUM. The SUM is on the right of the bar.

"rodchar" wrote:

hey all,
isn't there a way to select the a group of cells that contain numbers and
have it automatically show the sum on the status bar?

thanks,
rodchar

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default calculate on the fly

View Status Bar
right-click the Status bar and select sum
--
Gary''s Student - gsnu200743


"rodchar" wrote:

hey all,
isn't there a way to select the a group of cells that contain numbers and
have it automatically show the sum on the status bar?

thanks,
rodchar

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 80
Default calculate on the fly

Thanks everyone for the help.

"rodchar" wrote:

hey all,
isn't there a way to select the a group of cells that contain numbers and
have it automatically show the sum on the status bar?

thanks,
rodchar

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re-calculate No Name Excel Worksheet Functions 8 May 2nd 07 09:15 PM
calculate Joye Excel Worksheet Functions 2 January 18th 07 01:31 PM
How to calculate an age? PattiJ621 Excel Worksheet Functions 4 March 15th 06 04:46 PM
Calculate only if... cribology - ExcelForums.com Excel Discussion (Misc queries) 3 July 26th 05 06:54 PM
How do I calculate IRR? cs Excel Worksheet Functions 1 January 21st 05 09:54 PM


All times are GMT +1. The time now is 01:05 PM.

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

About Us

"It's about Microsoft Excel"