How to drag down sum indirect function

**Mayyalondon** · 03-11-2012, 08:39 AM

Hi Excel lovers,

I would like to sum columns A to E using Sum Indirect so if I insert more columns they will be ignored from the Sum.
In my first row (row2), I enter =SUM(INDIRECT("A2:E2")

Now I want to drag this down so row 3 will read =SUM(INDIRECT("A3:E3"). etc etc
But at the moment the formula doesn't change it still brings me the sum of row2.

What am I missing??

Many thanks
Mayya

**Marcol** · 03-11-2012, 09:32 AM

Why do you need to use INDIRECT()?
Would this not do the job?

Please Login or Register  to view this content.

[Edit]
Are you adding columns between A:E?
Then

Please Login or Register  to view this content.

or better still the non-volatile alternative

Please Login or Register  to view this content.

Finally if you are adding columns before and/or between A:E

Please Login or Register  to view this content.

**Cutter** · 03-11-2012, 09:47 AM

Seems an odd request regarding the "I would like to sum columns A to E using Sum Indirect so if I insert more columns they will be ignored from the Sum".

But this would do that:
=SUM($A2,$B2,$C2,$D2,$E2)