Summing 7 cells in the same row

[vibez_well]

Hi All,

Need some help here !

I have numerical values in cells A1:BI1. I need the sum of the first 7 cells(A1:G1) in A10. Then the next 7 cells (H1:N1) in A11 and so forth.



Please suggest a formula for it. Hope I will be able to drag the formula down from A10 and A11 to get similar sums for other rows. I tried tinkering with offset, but wasnt going ahead.

Thanks in advance.

 

[pgc01]

Hi

Try in A10:

=SUM(OFFSET($A$1,0,(ROWS($A$10:A10)-1)*7,1,7))

Copy down

 

[taurean]

In A10 and copy down
=SUM(OFFSET($A$1,0,(ROW()-9)*7,1,7))

 

[vibez_well]

Hi pgc01 & taurean,

Thanks for your replies. Sorry there was a typo in my post.
What I'm looking for is a sum of cells A1:G1 in A10. sum of H1:N1 in cell B10. sum of O1:U1 in C10.
So basically, I need every 7 cells in row 1 to be summed up and returned in consecutive cells in row 10. Would that be possible ?

Thanks again !

 

[Aladin Akyurek]

Hi pgc01 & taurean,

Thanks for your replies. Sorry there was a typo in my post.
What I'm looking for is a sum of cells A1:G1 in A10. sum of H1:N1 in cell B10. sum of O1:U1 in C10.
So basically, I need every 7 cells in row 1 to be summed up and returned in consecutive cells in row 10. Would that be possible ?

Thanks again !

A10, copied across:

=SUM(INDEX($A$1:$U$1,(COLUMNS($A$10:A1)-1)*7+1):INDEX($A$1:$U$1,(COLUMNS($A$10:A10))*7))

 

[pgc01]

In my formula, replace ROWS with COLUMNS

 

[vibez_well]

Perfect ! Thanks to everyone who replied