Forum Discussion
Putting totals at top of column - inconsistent formulas
Riny_van_Eekelen Thanks for your response. I tried doing that but it doesn't help. The totals are on line 8, line 9 is blank, and the entries start on line 10. So every time I make a new entry I put the cursor on line 10, right click, click on Insert Line, add the new entry. This changes the formulas and creates the problem. I'm not an expert at Excel, am I missing something? Thanks, Ken
Hello Ken1122
if the formula sums cells A10:A1000 and you insert a row in row 10, then the sum range will adjust. That is just how Excel works.
If you don't want the formula to include new rows, then insert these rows outside of the range that the formula refers to, i.e. select a cell in row 9 and insert a row there.
To make this easier, you may want to use a helper row just for that purpose, i.e. inserting rows above the summed range that will not change the sum range.