| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula adjust for inserted row above current row
I am averaging a column of numbers =Average(A1:A33) If I insert a row
"above" A1 the formula does not adjust to include the inserted row. Is there a way to make this work when you insert above the current row? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to fix a formula, so when a row is inserted it doesn't cha | Excel Discussion (Misc queries) | |||
| adjust formula to much info | Excel Discussion (Misc queries) | |||
| Can rows be inserted without having to manually adjust formulae | Excel Discussion (Misc queries) | |||
| Having the current time inserted w/o updating the current time | Excel Worksheet Functions | |||
| how to adjust formula dependent on current month | Excel Discussion (Misc queries) | |||
Threaded Mode
