| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autosum not Working
Why does autosum not capture all the cells in the formula?
I have input "=SUM(E4:E10)" in cell E11. Yet, when I go to input a new value in E5, the total sum in E11 does not change. I"ve never had that happen before. I've tried clearing out cells and it's not working. Help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autosum not Working
Goto Tools|Options|Calculation
and make sure that you have Automatic checked "Infrequent User" wrote: Why does autosum not capture all the cells in the formula? I have input "=SUM(E4:E10)" in cell E11. Yet, when I go to input a new value in E5, the total sum in E11 does not change. I"ve never had that happen before. I've tried clearing out cells and it's not working. Help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autosum not Working
Or just push F9 G. "Mike" wrote: Goto Tools|Options|Calculation and make sure that you have Automatic checked "Infrequent User" wrote: Why does autosum not capture all the cells in the formula? I have input "=SUM(E4:E10)" in cell E11. Yet, when I go to input a new value in E5, the total sum in E11 does not change. I"ve never had that happen before. I've tried clearing out cells and it's not working. Help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AutoSum | Excel Worksheet Functions | |||
| Autosum and Manual Sum not working | Excel Worksheet Functions | |||
| AutoSum | Excel Worksheet Functions | |||
| Why would autosum not be working? | Excel Discussion (Misc queries) | |||
| the autosum do not working propely ##### THAT WHAT APPEARS PLEA. | Excel Discussion (Misc queries) | |||
Hybrid Mode
