Excel 2K calculation problem...

[mcseguy9]

I have a user who says that, on occasion, when she puts in numbers for a simple calculation, like SUM, when she goes to sum them the formula doesn't work. There's nothing wrong with the formula. I've checked and re-checked. The formula is fine. I've checked in Tools>>Options and the file is set to calculate automatically.

When I opened the file up on my PC it acted the same way, but when I re-entered the values into the appropriate fields the calculation kicked in and worked properly. Any idea what's causing this and how to fix it?

 

[Rockn]

Are you trying to calculate the values on a field that has a formula in it as opposed to a numeric value?

 

[mcseguy9]

it's setup like this. there are 4 columns and 5 rows. column D has the values in it. so the values are in d1 thru d4, with the calculation being in d5. so the function is supposed to calculate the values in d1-d4 - =sum(d1:d4) - and it's not working unless you re-enter the values. hope this helps and thx for teh quick response.

 

[Rockn]

Are there values in A5 - D5? or is that a blank row and just D5 does the calculation? Look at the formulas in D1-D4....do they correspond correctly to the row they are associated with or not.

 

[mcseguy9]

the only values are in column D, d1-d4. The rest are filled with text for descriptive purposes. Kinda like this:

blah blah blah 5
blah blah blah 27
blah blah blah 108
blah blah blah 43
total =sum(d1:d4)