Sum Function
 

Ok, I must have hit an option I did not know of.... ??

I have a simple sum function on my spreadsheet. (=sum(B1:B10)
However, after setting the intial sum, when I change the contents of the row
source, the formula does not automatically update?? I do not recall this
workiong like this.
Example, in b1 through b10 the value is 1 so the =sum function cell would =
10.
now I change b1 to = 2 the sum shoudl automatically = 11 right? No it does
not, the value still shows 10 until I manually drag through the cells again
to refresh it? Please tell me there is a fix for this somewhere???


janell

Sum Function
 

Tools/Options/Calculation - set calc to automatic.


In article ,
Jcraig713 wrote:

Ok, I must have hit an option I did not know of.... ??

I have a simple sum function on my spreadsheet. (=sum(B1:B10)
However, after setting the intial sum, when I change the contents of the row
source, the formula does not automatically update?? I do not recall this
workiong like this.
Example, in b1 through b10 the value is 1 so the =sum function cell would =
10.
now I change b1 to = 2 the sum shoudl automatically = 11 right? No it does
not, the value still shows 10 until I manually drag through the cells again
to refresh it? Please tell me there is a fix for this somewhere???


janell

Sum Function
 

Hi janell,

Goto tools--- Options ---Calculation.

And select Automatic.

Good Luck,
Sivassou.

"Jcraig713" wrote:

Ok, I must have hit an option I did not know of.... ??

I have a simple sum function on my spreadsheet. (=sum(B1:B10)
However, after setting the intial sum, when I change the contents of the row
source, the formula does not automatically update?? I do not recall this
workiong like this.
Example, in b1 through b10 the value is 1 so the =sum function cell would =
10.
now I change b1 to = 2 the sum shoudl automatically = 11 right? No it does
not, the value still shows 10 until I manually drag through the cells again
to refresh it? Please tell me there is a fix for this somewhere???


janell

Sum Function
 

Try this:

From the Excel main menu:
<tools<options<calculation tab
Select: automatic (it's probably set for Manual)

Does that help?
***********
Regards,
Ron

XL2002, WinXP-Pro


"Jcraig713" wrote:

Ok, I must have hit an option I did not know of.... ??

I have a simple sum function on my spreadsheet. (=sum(B1:B10)
However, after setting the intial sum, when I change the contents of the row
source, the formula does not automatically update?? I do not recall this
workiong like this.
Example, in b1 through b10 the value is 1 so the =sum function cell would =
10.
now I change b1 to = 2 the sum shoudl automatically = 11 right? No it does
not, the value still shows 10 until I manually drag through the cells again
to refresh it? Please tell me there is a fix for this somewhere???


janell

Sum Function
 

Goto tools--- Options ---Calculation.

And select Automatic.


"Jcraig713" wrote:

Ok, I must have hit an option I did not know of.... ??

I have a simple sum function on my spreadsheet. (=sum(B1:B10)
However, after setting the intial sum, when I change the contents of the row
source, the formula does not automatically update?? I do not recall this
workiong like this.
Example, in b1 through b10 the value is 1 so the =sum function cell would =
10.
now I change b1 to = 2 the sum shoudl automatically = 11 right? No it does
not, the value still shows 10 until I manually drag through the cells again
to refresh it? Please tell me there is a fix for this somewhere???


janell