Preventing ever decreasing sums

[Journeyman3000]

Hi all

I have a row. in the first three cells there is fixed title data. in the 4th cell, I have a sum that calculates the following 10 cells along that row.

=SUM(E1:N1)

The problem is that I need to allow my user to delete E1, and add new data into column N. Once the user deletes column E, the sum automatically changes.

=SUM(#Ref)

How can I prevent this from occuring. I need to force this sum to do as it's told - and I'd rather not stand over it with a whip.

Any suggestions plz?

Cheers

[cffndncr]

Try using this:

=SUM(INDEX($1:$1,1,5):INDEX($1:$1,1,14))

[Journeyman3000]

Genius! Thank you very much. I love learning this stuff about excel.

Take a rep for your quick and excellent response!