Home » Questions » Computers [ Ask a new question ]

Calculate the sum of numbers in column G of MS Excel sheet

Calculate the sum of numbers in column G of MS Excel sheet

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?

Asked by: Guest | Views: 272
Total answers/comments: 2
Guest [Entry]

"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"
Guest [Entry]

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)