Excel- Sum a range

[septimus]

Hi all;
I have data in range A5:O5. I make a Sum function of range (A5:E5) in cell A6 and drag this formular to cell B6 and C6.How to make a automatic Sum function in B6 = sum(F5:J5) and C6=sum(K5:O5).
Regards!

 

[FDibbins]

What are your headings? you may be able to use SUMIF()

 

[Aladin Akyurek]

In A6 enter and copy across:

=SUM(INDEX($A$5:$O$5,0,(COLUMNS($A$5:A5)-1)*5+1):INDEX($A$5:$O$5,0,(COLUMNS($A$5:A5))*5))

 

[septimus]

Hi FDibbins;
Thank your concern.
I know Sumif function.
In my case, i want to know how to copy formula in from cell A6 to B6 and C6 and the range will changed every step by 5 cells instead of changing by step 1.
Regards!

 

[FDibbins]

Yes, I understand what you want to do, but if you have headings that may show which columns you are dealing with, then SUMIF may be an option

 

[septimus]

Thank Aladin!
It's great!

 

[Aladin Akyurek]

See post 3...

By the way, the following does the same, which is in terms of OFFSET...

=SUM(OFFSET($A$5,0,((COLUMNS($A$6:A6)-1)*5+1)-1,1,5))

 

[Aladin Akyurek]

Thank Aladin!
It's great!

You are welcome.

 

[septimus]

It look more simple and easier to apply in my excel board.
Thank again!