Simple Sum Forumla Not Working

[DC_United_Capitals_Fan]

I dont know what I am doing wrong, but its frustrating as hell! I have plenty of excel experience, but this one has me stummped. Im using the sum formula =SUM(G3:G30), and it will NOT display the total in that colum. It only displays the formula. What am I doing wrong? Thanks!

 

[Jonmo1]

1. Make sure the cell is formatted as General or Number (BEFORE Entering the formula)
2. Tools - Options - View - UNcheck "Formuals"

Hope that helps..

 

[LaOs]

The formatting for the cell with the formula is more than likely set to Text. Change the format of the cell to general and re-enter the formula and it should work like a charm.

[Edit]
Oh jonmo, I'm beat'd again. :P

 

[Richard Schollar]

Hi

Either the cell is formatted as Text (in which case you need to convert to General number format and reenter the formula), or under Tools>Options>View in the Windows Options section you have Formulas checked.

 

[DC_United_Capitals_Fan]

Thanks everyone so much! I knew it was gonna be the dumbest smost simple thing in the world! Figures. LOL! Thanks again!