Sum the ranges

A

Andri

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
 
T

Toppers

Just to clarify ...

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

Or have I completely misunderstood?
 
A

Andri

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

Toppers

Try (and copy down):

in F105

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

Similar logic for G & H
 
Top