Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Excel: wrong auto sum


(!)

overz's Avatar
overz overz is offline
Junior Member with 6 posts.
THREAD STARTER
 
Join Date: Nov 2004
Experience: Beginner
03-Nov-2004, 02:45 AM #1
Excel: wrong auto sum
Hi,
my problem is the wrong answer for auto sum. for example,
A B
1 2
1 3
result 2 2 -->using Auto sum function


cell B3 the result should be 5 but result is = 2
However, the result will be correct after i save the file.
what wrong with this formula? Is the file has a virus? I scaned Virus but can't detact it.
please help me
thx,

Last edited by overz; 03-Nov-2004 at 02:56 AM..
ChuckE's Avatar
Member with 2,310 posts.
 
Join Date: Aug 2004
Location: Redondo Beach, CA
Experience: Advanced
03-Nov-2004, 04:16 AM #2
Forget about what the result is, just tell us what the formula is in the cells.
Just clicking [AutoSum] only automates the assumed action that Excel thinks you want for the selected cells.

I just tried it on this end, and the formula I got in the cells
A3 is =SUM(A1:A2)
B3 is =SUM(B1:B2)

If those are not the formulas that you are getting, in those cells, then please tell us what you do have.

Last edited by ChuckE; 03-Nov-2004 at 01:08 PM..
overz's Avatar
overz overz is offline
Junior Member with 6 posts.
THREAD STARTER
 
Join Date: Nov 2004
Experience: Beginner
03-Nov-2004, 04:26 AM #3
The formular is correct B3 is SUM(B1:B2)
but still have a wrong result,
Thx in advance




Quote:
Originally Posted by ChuckE
Forget about what the result is, just tell us what the formula is in the cells.
Just clicking [AutoSum] only automates the assumed action that Excel thinks you want for the selected cells.

I just tried it on this end, and the formula I got in the cells
A3 is =SUM(A1:A2)
B3 is =SUM(B1:B2)

If that is not the formulas that you are getting, in those cells, then please tell us you do have.
kiwiguy's Avatar
Member with 17,584 posts.
 
Join Date: Aug 2003
Location: New Zealand
03-Nov-2004, 04:42 AM #4
It's because you have cell B3 formatted as text. Its not being seen as a "number"
overz's Avatar
overz overz is offline
Junior Member with 6 posts.
THREAD STARTER
 
Join Date: Nov 2004
Experience: Beginner
03-Nov-2004, 07:43 AM #5
It's number format but still uncorrect result.
any comment,
Andyatvanda's Avatar
Andyatvanda Andyatvanda is offline
Junior Member with 21 posts.
 
Join Date: Oct 2004
Location: Milano, Italia
Experience: Intermediate/Beginner
03-Nov-2004, 07:53 AM #6
Can you tell us the following:
1. Select Tools > Options and select the Calculation tab. Is it set to Manual rather than Automatic?
2. How did you get the formula into B3 - did you use Copy and Paste from A3?
Zack Barresse's Avatar
Computer Specs
Member with 5,434 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
03-Nov-2004, 02:48 PM #7
Selecting one column at a time (as you only have questions about B, I'd select that one, range B1:B2), click Data -> Text to Columns -> ensure Delimited is selected -> Finish. This will transfer your textual numbers to actual numbers so excel can *see* it in calculations.

Another way would be to type 1 in a blank/unused cell, then copy it. Select cell(s) in question, paste special -> Multiply.



HTH
overz's Avatar
overz overz is offline
Junior Member with 6 posts.
THREAD STARTER
 
Join Date: Nov 2004
Experience: Beginner
04-Nov-2004, 03:12 AM #8
waiting for all help
At the calculateion tab, it set to Manual
I copy and paste from A3. however, the formula in B3 is show Sum(B1:B2)


Quote:
Originally Posted by Andyatvanda
Can you tell us the following:
1. Select Tools > Options and select the Calculation tab. Is it set to Manual rather than Automatic?
2. How did you get the formula into B3 - did you use Copy and Paste from A3?
ChuckE's Avatar
Member with 2,310 posts.
 
Join Date: Aug 2004
Location: Redondo Beach, CA
Experience: Advanced
04-Nov-2004, 03:37 AM #9
Put a copy of your file in the thread here, and somebody can look it over. My guess is there is nothing wrong with your sheet, but either a setting in your Excel Options, or some odd setting you have in your Windows OS.

But, if we can see the sheet for ourselves, and see that it works here, then at least we can rule out your sheet.
overz's Avatar
overz overz is offline
Junior Member with 6 posts.
THREAD STARTER
 
Join Date: Nov 2004
Experience: Beginner
04-Nov-2004, 03:42 AM #10
step by step
here is the step by step what i have done.
I can't upload my excel. it is not accept excel file. Moreover, I try with other computer. They still have a same problem with this file.
Attached Files
File Type: doc Auto Sum.doc (138.5 KB, 191 views)
Andyatvanda's Avatar
Andyatvanda Andyatvanda is offline
Junior Member with 21 posts.
 
Join Date: Oct 2004
Location: Milano, Italia
Experience: Intermediate/Beginner
04-Nov-2004, 04:22 AM #11
OK.

I managed to recreate your problem.

If the calculation in Tools > Option is set to manual and you copy and paste the formaula from A3, it copies the formula to B3 correctly (i.e. shows the formula as sum(B1:B2)) but does not give the correct answer. Rather it shows 2 and not 5.

Change the Manual to Automatic (in Tools > Options) or use the F9 key (Calc now) when you have copied the formula.

I hope this helps.
Zack Barresse's Avatar
Computer Specs
Member with 5,434 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
04-Nov-2004, 11:34 AM #12
If this is an Automatic Calculation issue, test by pressing F9. If you see change (generally), that is your problem, if not it is something else.
ChuckE's Avatar
Member with 2,310 posts.
 
Join Date: Aug 2004
Location: Redondo Beach, CA
Experience: Advanced
04-Nov-2004, 01:06 PM #13
You can upload the Excel spreadsheet here; just change the extension to one of the acceptable extensions first, like to .txt. Then just let us know what to change it back to, to open it.
overz's Avatar
overz overz is offline
Junior Member with 6 posts.
THREAD STARTER
 
Join Date: Nov 2004
Experience: Beginner
04-Nov-2004, 09:21 PM #14
problem is slove
Thansk you for all help. Now my problem have been slove. After I change the Calculation from Manual to Automatic. It's working perfect.
Thanks for all support.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
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.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 2 (0 members and 2 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑