How to fix a formula, so when a row is inserted it doesn't cha
Earl
this was very useful to me too. I need to use INDIRECT("B49")-INDIRECT("A49")
and then copy this formula down over 300 rows so the next row would read
INDIRECT("B50")-INDIRECT("A50"). When I try to copy the formula it doesnt
update to the new row but remains using INDIRECT("B49")-INDIRECT("A49")
Yor assistance would be greatly appreciated
"Earl Kiosterud" wrote:
Matjaz,
YOu're right, the absolute references are for copies only. They don't
prevent cell references from changing when cells are moved. Use
INDIRECT("A1") + INDIRECT("A2") ...
or
=SUM(INDIRECT("A1:A3"))
These aren't cell references -- they're text. They won't change when the
cell gets moved.
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
"Matjaz" wrote in message
...
I have a row with data added daily, newest on the top. Then I have a
formula
which calculates some output according to the last three inserted cells
(i.e.
=A1+A2+A3). But everytime I add data (insert a row) formula changes (i.e.
to
=A2+A3+A4). I tried to surround formula with $ signs (i.e.
=$A$1+$A$2+$A$3)
but it doesnt help (looks like absolute references only apply to copying
formulas).
Is there something else I could try? Maybe something like =%A%1+%A%2+%A%3
or
some other character?
|