M
Manfred
This would appear to be a very simple problem but I can't seem to find a
solution in my Excel manual, and would greatly appreciate some help if
possible.
I've got a formula as follows at the top of a worksheet:
=SUM(E$7:E$11)/5
Each week, I want to insert a new row with data, so that E7 is always the
latest row, and the 4 lower rows beneath are always summed to E7. I want
the formula to continue calculating only for rows E7 through E11, and thus I
don't want the formula to change to:
=SUM(E$8:E$12)/5
when a new row is inserted.
As seen above, putting a '$' in front of the row, or '$' before the column
and one before the row, does not appear to make a difference --the
spreadsheet still alters the formula.
So the question is how do I freeze the formula so nothing changes in it
whether I've inserted 1 or more rows.
Any assistance greatly appreciated.
solution in my Excel manual, and would greatly appreciate some help if
possible.
I've got a formula as follows at the top of a worksheet:
=SUM(E$7:E$11)/5
Each week, I want to insert a new row with data, so that E7 is always the
latest row, and the 4 lower rows beneath are always summed to E7. I want
the formula to continue calculating only for rows E7 through E11, and thus I
don't want the formula to change to:
=SUM(E$8:E$12)/5
when a new row is inserted.
As seen above, putting a '$' in front of the row, or '$' before the column
and one before the row, does not appear to make a difference --the
spreadsheet still alters the formula.
So the question is how do I freeze the formula so nothing changes in it
whether I've inserted 1 or more rows.
Any assistance greatly appreciated.