Sum the ranges

[Guest]

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

 

[Guest]

Just to clarify ...

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

Or have I completely misunderstood?

 

[Guest]

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..

 

[Guest]

Try (and copy down):

in F105

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

Similar logic for G & H

 

[Guest]

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

 

[Guest]

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