Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2003 sum formula problem

16 Jul 2011   #1
thenoo

Windows 7 Home Premium x64
 
 
Excel 2003 sum formula problem

I have been entering currency data in Column B in Euros to an EXCEL 2003 s/s and the formula used has added these totals entered in that Column correctly until I reached a total sum of 74364.70 Euros ,this being the sum of entries in Rows B6 to B82 . This was reached with the formula showing as "=SUM(B6:B82)" - without quotation marks.

The next entry into Row 83 was a sum of 27618.75 Euros.Entry of this into Column B caused the cell showing the totals to change to a series of #### but with the new total showing correctly in parenthisis when the pointer was hovered over that cell. The formula was showing as expected as "=SUM(B6:B83)".

When I experimented with other entries into Column B , I found EXCEL adding these correctly to the Total of Column B but only if the total reached after any entries did not reach or exceed a figure of 100,000 !

Can anyone please explain what the problem is here ?


My System SpecsSystem Spec
.
17 Jul 2011   #2
Irene

Windows 7 Home Premium 64bit
 
 

It simply means that your column be needs to be wider.

Hover your cursor over the right hand side of the top of 'B' until you see an upright line with arrows pointing left and right > hold down a right-click and drag to the right (alternatively just double-click the line with arrows - that should extend the width to the correct point).
My System SpecsSystem Spec
17 Jul 2011   #3
thenoo

Windows 7 Home Premium x64
 
 

Thanks Irene - that solved it !

I'm not a frequent user of EXCEL but I've never come across that problem before . Previously , when anything I've entered into a cell was too big for that cell , this merely resulted in the overhanging balance of the data being left out - a fact which then made it obvious that the column required to be made wider . This was the first time I got that result with the hashes appearing in the TOTAL cell which contained the SUM Formula. Perhaps this was the first time it happened for me using numeric data - I was usually only entering script before I suppose.

I live and learn - thanks to all the kind helpers in these Forums!
My System SpecsSystem Spec
.

17 Jul 2011   #4
seavixen32

Windows 7 Ultimate SP1 64-Bit
 
 

You can also do it via Format>AutoFit Column Width.
My System SpecsSystem Spec
17 Jul 2011   #5
Irene

Windows 7 Home Premium 64bit
 
 

Quote   Quote: Originally Posted by thenoo View Post
Thanks Irene - that solved it !

I'm not a frequent user of EXCEL but I've never come across that problem before . Previously , when anything I've entered into a cell was too big for that cell , this merely resulted in the overhanging balance of the data being left out - a fact which then made it obvious that the column required to be made wider . This was the first time I got that result with the hashes appearing in the TOTAL cell which contained the SUM Formula. Perhaps this was the first time it happened for me using numeric data - I was usually only entering script before I suppose.

I live and learn - thanks to all the kind helpers in these Forums!
The #'s only appear with numerical data is to wide for the column.

When you have entered text, it will extend across the next cell (providing that nothing is entered there). Should there be an entry in the next cell, the problem can be resolved by a right-click in the cell (where the text is) > format the cell > alignment > check the option for 'wrap text'. That will automatically make the row deeper to allow the text to 'wrap'.
My System SpecsSystem Spec
Reply

 Excel 2003 sum formula problem




Thread Tools




Similar help and support threads
Thread Forum
Excel 2013 - how to keep a formula consisten
Hi I am trying to tie one cell into a formula that is being pasted into multiple rows. I know you can use $ to keep the cell consistent but it doesn't seem to be working. So if the value is in c9 and then first row gets c9 then the new row gets c10 etc... I need it to be c9 throughout the...
Microsoft Office
Excel Formula
Hello Sir, Can you let me know the formula in Excel: I have a table as below: This table, At the column "A,Status" when i Put the word" Completed", it's will automatic put current Date to Column "B, Row 2". But i don't know after that when tomorrow arrived,at the column "B,Row 2",...
Microsoft Office
Excel Formula Help please...
This is probably very simple and I have got it working but it isn't working how I want it to work. I have created an Excel document to show my monthly payments of a bank loan. I have created 3 columns in the first column is the payment number, in the second column is the amount that the loan...
Microsoft Office
excel syntax problem for formula... difference in days
if I have 2 columns of dates and I want to find the number of days between the days of D2 and C2, what is the syntax for the formula so that the result in column E is x number of days between the two dates
Microsoft Office
Cant scroll while editing formula Excel 2007
Hi I'm unable to scroll while editig a formula in excel 2007. i know it can be done if i edit directly in cell but i prefer editing in the formula bar. I've seen an apparent solution in some forum which says change the mouse setting in the control panel (the wheel tab). Start --> Settings -->...
Microsoft Office
Problem with Excel 2003 files with Windows 7
New computer has windows 7 op system. When I transfer Excel files from my laptop (using XP Home) I get an error message saying 'There was a problem sending the command to the program' Any idesa what the solution is? The files were generated on Excel 2003.
Hardware & Devices


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 04:02.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App