Excel Formula help (INDIRECT)

[AmDaMan]

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,

 

[AmDaMan]

lol

That's the problem mate, it won't just drag down with this formula, i think you have to tie it in with another formula.

Cheers for the help though

 

[AmDaMan]

I've seen that page and that's the reason i've used indirect because when I delete a cell i don't want it to display #ref! or anything. I want it to stay absolute to say 'K20' Even if I delete a column.

The problem is I can't drag the formula down so it applies to the cell underneath it for example.

There must be a way though!