Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

When I calculate the sum of numbers in the column G of a Microsoft Excel spreadsheet by using the formula =SUM(G1,G31) ,column G32 prints the date (0-Jan-00). Is there any way in which the sum of numbers in the column G can be calculated?

I am using MS excel 2003 SP3.

share|improve this question
add comment

5 Answers

up vote 0 down vote accepted

Hmm. Interesting.

A couple of random ideas (to try on a copy of your work book)...

1) Make sure there is no conditional formatting in effect for cell G32

2) Try cutting an adjacent cell that does work onto cell G32, then fix the formula so it calculates for column G.

3) Delete column G, then insert a new column and recreate the data and calculation

4) It is possible the workbook is corrupted;

  • Open Excel (without opening you workbook)
  • Use FILE / OPEN, and navigate to the your workbook. Click Once on he workbook.
  • Click on the Down Arrow that is on the OPEN button, and select OPEN AND REPAIR
share|improve this answer
    
tried 2) and 3)... it works ...thanks a lot!!! –  rohit Dec 30 '09 at 5:57
    
You are welcome. Have a fine New Year. –  Kije Dec 30 '09 at 15:10
add comment

The format of cell G32 must be set to date.

Change it to General. That is, numbers.

share|improve this answer
add comment

It's been a while since I used excel, but from what I recall, if you're trying to sum the values in the cells between G1 and G31, you want =SUM(G1:G31) (colon, rather than comma)

share|improve this answer
add comment

You probably have the cell's formatting set to date format. Changing it to General should fix the problem:

alt text

For future reference there is a much easier way to sum values than writing your own formulas.

  • Highlight all of the cells you want to sum
  • Click the AutoSum icon in the toolbar that looks like this:

alt text

  • The sum should be placed in the cell immediately below the last value in the sum (G32 for you)
share|improve this answer
    
Thanks for the quick response. The formatting of all the cells is set to 'General' and not date. This problem happens only with the column G and not with any other column. I did try the Autosum icon also .However even that does not work. –  rohit Dec 29 '09 at 4:56
    
What about the G32 cell? –  John T Dec 29 '09 at 5:00
    
The G32 cell is also General. I am actually calculating the the sum for some data for the whole year.I can make t work for 11 months except for July(represented in column G). –  rohit Dec 29 '09 at 5:06
add comment

Chance is that one of the fields in the row you want to calculate is set to date.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.