| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Automatic Adding
Not sure if i used the right formula to begin with to calculate the sum of 7
different cell ( D5-J5 ) ...i just went to Math , sum, then typed in D5+E5+F5....and so on. But now i want to have the total amount figured out automatically as hours change per week...is that possible?? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Automatic Adding
Hello,
You can use =sum(D5:J5) for the calculation as opposed to D5+E5.... Check under Tools | Options | Calculations Is Automatic checked? HTH Roger "Help newbie" wrote: Not sure if i used the right formula to begin with to calculate the sum of 7 different cell ( D5-J5 ) ...i just went to Math , sum, then typed in D5+E5+F5....and so on. But now i want to have the total amount figured out automatically as hours change per week...is that possible?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
| Automatic Value | Excel Discussion (Misc queries) | |||
| Automatic Calculation | Excel Discussion (Misc queries) | |||
| Please help with adding automatic data. | Excel Discussion (Misc queries) | |||
| Adding percentages in a column and automatic formating of contents | Excel Worksheet Functions | |||
Linear Mode
