| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Rows To Update A Formula
Whoever can help
How do you update a cell sum to include a row you have just added to either the top of your stack or the bottom. For example if I have the numbers 5,5,5 in cells A3,A4,A5 respectively and my sum cell is A7 and I add a row either above A43 or below A5 the forumla won't recognise to include these? Whereas if I added a row between A3,A4 it would. I would have thought this may have needed a VB function? Thanks you in advance for any replies |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula range doesn't update for new rows | Excel Worksheet Functions | |||
| Summarize Data and automatically update including adding rows | Excel Discussion (Misc queries) | |||
| Adding and Deleting rows - update formulas help needed. | Excel Worksheet Functions | |||
| when adding new rows starting point of the formula doesn't update | Excel Discussion (Misc queries) | |||
| Formula doesn't update when rows are inserted | Excel Worksheet Functions | |||
Threaded Mode
