Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
cowboy
 
Posts: n/a
Default sum total - not changing?

i feel like a complete idiot,, it has been some time since ive used exel, but
i swear that i remember that this worked... i have a column of numbers that
ive autosummed,, why doesnt the autosum change when i change one or any of
the numbers in that column?
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Does it re-calculate if you hit the F9 key?

ToolsOptionsCalculation. Perhaps you have it set for Manual?


Gord Dibben Excel MVP

On Fri, 28 Jan 2005 16:33:02 -0800, cowboy
wrote:

i feel like a complete idiot,, it has been some time since ive used exel, but
i swear that i remember that this worked... i have a column of numbers that
ive autosummed,, why doesnt the autosum change when i change one or any of
the numbers in that column?


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
keep a running total of my formula results after each (F9) Souvien Excel Discussion (Misc queries) 1 January 23rd 05 01:59 AM
Total remaining formula jbsand1001 Excel Worksheet Functions 2 January 6th 05 04:17 PM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM
how do i set up a single cell continual entry in excel to total f. mike@swallow Excel Discussion (Misc queries) 1 December 7th 04 12:29 PM
Create a total based on multiple conditions is not giving correct. Jacob Excel Worksheet Functions 2 November 4th 04 04:07 AM


All times are GMT +1. The time now is 04:11 AM.

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"