Windows, Operating System, Security, Networking, Malware, Support, Forum, Help Site Check Our Facebook Page!
Notices
Other PC Software Post questions here about PC Applications, Office Software, Games etc.


Register your FREE account to unlock additional features at WindowsBBS.com
   
 
 
LinkBack Thread Tools
Old 5th August 2004   #1
Inactive
THREAD STARTER
 
Profile:
Join Date: Apr 2002
Location: Raleigh, NC
Posts: 50
Computer Experience:
Intermediate
rtstanley Reputation Level

Angry

Excel Sum Function Not Working Correctly


Are there any Excel experts out there that would like to have a look?
I have rows and columns. If I add the columns up manually in a formula (e.g. A1+A2+A3+A4+A5, etc) the result is correct. However, if I use the SUM function (e.g. =SUM(A1:A5), the results are not correct. I have the same sort of problem when summing rows. Please HELP! Looks like an excel bug to me. I would be happy to send a small excel file to someone if they care to take a look. Thanks as always!


Last edited by rtstanley; 5th August 2004 at 03:38. Reason: To change email notification
rtstanley is offline  

 

Register
to remove this ad.
 
 

Old 5th August 2004   #2
Alumni
 
Profile:
Join Date: May 2004
Location: Worcs. UK
Posts: 2,786
Computer Experience:
Unabashed deviant
ReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation Level

Which version of Excel? I can't believe that such a commonly used function would fail so obviously - I think it is probably something wrong with your installation or coruption in the sheet.

ReggieB is offline  

Did you find this post helpful? Yes | No
Old 5th August 2004   #3
Inactive
 
Profile:
Join Date: Jan 2003
Posts: 1,111
Computer Experience:
par
merlin Reputation Level

Strange ! Do the cells you add have different decimal sizes, different numerical sizes ? Have you any "automate" options set ? Are the fields
you add up on the same worksheet/workbook ?
regards


Last edited by merlin; 5th August 2004 at 15:02.
merlin is offline  

Did you find this post helpful? Yes | No
Old 5th August 2004   #4
Inactive
 
Profile:
Join Date: Jan 2003
Posts: 1,111
Computer Experience:
par
merlin Reputation Level

Just had another thought on this.
If you set a cell to =Sum(A1:A4) - is correct ?
Or =Sum(A2:A5) is OK ? and so on ... (A4:A5) ....
Trying to see if a cell is corrupted ...
regards

merlin is offline  

Did you find this post helpful? Yes | No
Old 5th August 2004   #5
Alumni
 
Profile:
Join Date: May 2004
Location: Worcs. UK
Posts: 2,786
Computer Experience:
Unabashed deviant
ReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation LevelReggieB Reputation Level

Nice direction you're going in Merlin. If the cells are different formats you may get some odd results - especially if one is a date or time.

Following on from Merlin, Copy the cells you are adding up. Then right click in an empty area of sheet and select "Paste Special". Select to paste values only. Then try to sum the pasted values. What do you get then?

Also just create a line of five cells and put a "1" in each cell. Then SUM those cells. Do you get 5? If not there's something wrong with your Excel install.

SUM is a function - just a predefined function as opposed to user define function. It is possible it has become corupted. If so a reinstall of Office might fix it. If that doesn't it is a case of tracking down the root template, deleting that and reinstalling I think.

ReggieB is offline  

Did you find this post helpful? Yes | No
Old 7th August 2004   #6
Inactive
THREAD STARTER
 
Profile:
Join Date: Apr 2002
Location: Raleigh, NC
Posts: 50
Computer Experience:
Intermediate
rtstanley Reputation Level

I figured out my problem. I had actually created another spreadsheet from a text file (comma delimited). As I stepped through the excel screens, I inadvertently set one of the column formats as text only. When you cut-n-paste this into another spreadsheet, it "looks" like numbers in the cells - but excel treats the cell as text. If you double-click each cell, then hit carriage return, the cell converts to number (actually general).

Sorry for wasting some of your time. I love this usergroup.

rtstanley is offline  

Did you find this post helpful? Yes | No
Old 7th August 2004   #7
Inactive
 
Profile:
Join Date: Jan 2003
Posts: 1,111
Computer Experience:
par
merlin Reputation Level

Hi, pleased you solved the problem and thanks for posting back.
No need to be sorry about wasting anyone's time - it was a problem,
it got solved and we are all the wiser !
regards

merlin is offline  

Did you find this post helpful? Yes | No


 

THIS THREAD HAS EXPIRED.

Are you having the same problem? Please post a new thread, but first you'll have to join us by Registering (FREE).



Discussion Forums
Operating Systems
Windows 8 Windows 8
Windows 7 Windows 7
Windows Vista Windows Vista
Windows XP Windows XP
Windows Server System Windows Server System
Legacy Windows OS Legacy Windows OS
Internet & Networking
Networking (Hardware & Software) Networking
Internet Explorer Internet Explorer
Microsoft Mail Microsoft Mail
Firefox, Thunderbird & SeaMonkey Firefox, Thunderbird
      & SeaMonkey

Web Applications & Cloud Web Applications & Cloud
General Internet
Security
Malware and Virus Removal Malware and Virus
     Removal

Security and Privacy Security and Privacy

Other
Other PC Software Other PC Software
Test Posts Test Posts
Hardware
PC Hardware PC Hardware
Mobile Devices Mobile Devices
Community
Introductions Introductions
General Discussions General Discussions
Site Comments & Suggestions Site Comments
      & Suggestions

News News @ WindowsBBS

Thread Tools


Find us on Facebook   Web Of Trust Rating

All times are GMT. The time now is 13:00.


Recent Discussions
Microsoft Windows 7 Support to End .. (1)
Wrong CPU Installing (4)
Win 7 32 to win 7 64 bit using Easy.. (1)
Windows 7 OLEAUT32.DLL Error (2)
Microsoft July 2014 Security Bullet.. (0)
External Hard Drive Question. (1)
MS security updates just released (1)
Malwarebytes Anti Exploit or MS EME.. (15)
Problem with resetting my outlook e.. (0)
XP fails to boot (2)
Dump Data : BSoD 0x000000BE, bcmwl6.. (1)
converting office 2000 files to win.. (10)
Make an original shortcut (5)
Can no longer see part of a logical.. (1)
Unable to print messages from TB 24.. (1)
lost ability to Copy/Paste, see ser.. (4)
No Boot Device Listed In Windows 8... (5)
Cannot mount Seagate to Router (10)
Change audio file associations in W.. (17)
Internet connection lost in sleep m.. (6)


Donate!
Support Windows BBS!



Powered by vBulletin® Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO
Copyright 2002 - 2013 WindowsBBS.com. All rights reserved.
FDMA Media LLC
Terms of Use, Legal Information & Privacy Policy
Page generated in 0.08604 seconds with 7 queries