Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic Formulas not calculating
All of the sudden, formulas are not calculating. This is happening in
completely different spreadsheets. Its as if they aren't calculating. For example, I have this formula =SUM(E4:E38), and its returning a zero. And yes, I have numbers in that range. :) Any ideas?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic Formulas not calculating
Tools/ Options/ Calculation
Make sure it's set to Automatic, not Manual. -- David Biddulph "jzkall" wrote in message ... All of the sudden, formulas are not calculating. This is happening in completely different spreadsheets. Its as if they aren't calculating. For example, I have this formula =SUM(E4:E38), and its returning a zero. And yes, I have numbers in that range. :) Any ideas?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic Formulas not calculating
Perhaps the cell format for E4 through E38 (maybe the whole column) has
become Text... you can't sum text even if that text looks like a number. Right click a cell with one of your "numbers" in it and click FormatCells from the popup menu to see what format the cell actually is. Rick "jzkall" wrote in message ... All of the sudden, formulas are not calculating. This is happening in completely different spreadsheets. Its as if they aren't calculating. For example, I have this formula =SUM(E4:E38), and its returning a zero. And yes, I have numbers in that range. :) Any ideas?? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic Formulas not calculating
I had checked both of those after reading some other posts. Its set to
'Automatic', and I have the whole worksheet set to 'General'. I opened the same spreadsheet on someone else's computer, and it worked fine. So it might be specific to my settings, just can't figure out what it is. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Basic question about what formulas look at. | Excel Worksheet Functions | |||
Not Calculating Formulas. | Excel Worksheet Functions | |||
Calculating basic averages...a question | Excel Worksheet Functions | |||
not calculating formulas | Excel Discussion (Misc queries) | |||
Formulas not calculating | Excel Worksheet Functions |