View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_4_] Sheeloo[_4_] is offline
external usenet poster
 
Posts: 225
Default function does not calculate remain as =SUM(E9:E10)

Check and make sure that the format of the cells containing the formula is
NOT text... change it to GENERAL.

If that does not help then make sure that there is no ' at the beginning of
the cell.

Finally press CTRL-` once...

` is on the key having ~, usually on the top left corner of the key board.

"Claude" wrote:

All functions remain in text format and my worksheet does not calculate it. I
am on auto for calculate? A simple addition, a simple IF does not execute???