Hi chaps, quick question.
If I have the formula;
=SUM(INDIRECT("I16:J16"))
How can I make it possible to drag the formulae to drag it to drag the formula so it auto fils to other cells.
eg;
J17, j18 etc.
The reason i'm using indirect is so I don't get #ref! when I delete a cell, which I sometimes have to do.
Thanks,
If I have the formula;
=SUM(INDIRECT("I16:J16"))
How can I make it possible to drag the formulae to drag it to drag the formula so it auto fils to other cells.
eg;
J17, j18 etc.
The reason i'm using indirect is so I don't get #ref! when I delete a cell, which I sometimes have to do.
Thanks,