Sum the ranges
 

Please help...
i have a range F1:H100, i would like to sum with this criteria
Column A, starting from F1:F12, the formula at F105
Column B, starting from G5:G17, the formula at G105
Column C, starting from H20:H32, the formula at H105

Basically, i would like to sum for total 12Rows, but different unique start
of Row number?

Thank you and TIA

Sum the ranges
 

Just to clarify ...

Could F105 contain any range of 12 rows from F1 onwards e.g. F10:F21?

Or have I completely misunderstood?

"Andri" wrote:

Please help...
i have a range F1:H100, i would like to sum with this criteria
Column A, starting from F1:F12, the formula at F105
Column B, starting from G5:G17, the formula at G105
Column C, starting from H20:H32, the formula at H105

Basically, i would like to sum for total 12Rows, but different unique start
of Row number?

Thank you and TIA

Sum the ranges
 

No, F105, only contains F1 to F12...
then later i plan to entry at F106...to sum from F13 to F24...

the same with G105 and H105....

Thank for the response..


"Toppers" wrote:

Just to clarify ...

Could F105 contain any range of 12 rows from F1 onwards e.g. F10:F21?

Or have I completely misunderstood?

"Andri" wrote:

Please help...
i have a range F1:H100, i would like to sum with this criteria
Column A, starting from F1:F12, the formula at F105
Column B, starting from G5:G17, the formula at G105
Column C, starting from H20:H32, the formula at H105

Basically, i would like to sum for total 12Rows, but different unique start
of Row number?

Thank you and TIA

Sum the ranges
 

Try (and copy down):

in F105

=SUM(OFFSET($F$1,(ROW()-105)*12,0,12))

Similar logic for G & H


"Andri" wrote:

No, F105, only contains F1 to F12...
then later i plan to entry at F106...to sum from F13 to F24...

the same with G105 and H105....

Thank for the response..


"Toppers" wrote:

Just to clarify ...

Could F105 contain any range of 12 rows from F1 onwards e.g. F10:F21?

Or have I completely misunderstood?

"Andri" wrote:

Please help...
i have a range F1:H100, i would like to sum with this criteria
Column A, starting from F1:F12, the formula at F105
Column B, starting from G5:G17, the formula at G105
Column C, starting from H20:H32, the formula at H105

Basically, i would like to sum for total 12Rows, but different unique start
of Row number?

Thank you and TIA

Sum the ranges
 

Thank you, it is workable....and solving my weekend case...



"Toppers" wrote:

Try (and copy down):

in F105

=SUM(OFFSET($F$1,(ROW()-105)*12,0,12))

Similar logic for G & H


"Andri" wrote:

No, F105, only contains F1 to F12...
then later i plan to entry at F106...to sum from F13 to F24...

the same with G105 and H105....

Thank for the response..


"Toppers" wrote:

Just to clarify ...

Could F105 contain any range of 12 rows from F1 onwards e.g. F10:F21?

Or have I completely misunderstood?

"Andri" wrote:

Please help...
i have a range F1:H100, i would like to sum with this criteria
Column A, starting from F1:F12, the formula at F105
Column B, starting from G5:G17, the formula at G105
Column C, starting from H20:H32, the formula at H105

Basically, i would like to sum for total 12Rows, but different unique start
of Row number?

Thank you and TIA

Sum the ranges
 

Glad it's working ... have a good (rest of) weekend.

"Andri" wrote:

Thank you, it is workable....and solving my weekend case...



"Toppers" wrote:

Try (and copy down):

in F105

=SUM(OFFSET($F$1,(ROW()-105)*12,0,12))

Similar logic for G & H


"Andri" wrote:

No, F105, only contains F1 to F12...
then later i plan to entry at F106...to sum from F13 to F24...

the same with G105 and H105....

Thank for the response..


"Toppers" wrote:

Just to clarify ...

Could F105 contain any range of 12 rows from F1 onwards e.g. F10:F21?

Or have I completely misunderstood?

"Andri" wrote:

Please help...
i have a range F1:H100, i would like to sum with this criteria
Column A, starting from F1:F12, the formula at F105
Column B, starting from G5:G17, the formula at G105
Column C, starting from H20:H32, the formula at H105

Basically, i would like to sum for total 12Rows, but different unique start
of Row number?

Thank you and TIA