Excel 2K calculation problem...

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

mcseguy9

Thread Starter
Joined
Jun 11, 2001
Messages
387
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?
 
Joined
Jul 29, 2001
Messages
21,334
Are you trying to calculate the values on a field that has a formula in it as opposed to a numeric value?
 

mcseguy9

Thread Starter
Joined
Jun 11, 2001
Messages
387
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.
 
Joined
Jul 29, 2001
Messages
21,334
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

Thread Starter
Joined
Jun 11, 2001
Messages
387
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)
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top