Combining subtotal sum with offset using an array for row reference

[John Vieren]

Hi,

Thanks for reading my Thread.

The problem I have is as follows:

1) 3 data sets 1440 rows each with 12 blank spaces inbetween down 1 column
2) I like to sum every 12 months for the 3 data sets
3) I figured out the formula for the first data set
4) Am trying to use the subtotal function with sum and and an array as the row reference for the 3 data sets but it is not working
5) My workbook is attached

Thanks for your help John

[sktneer]

Try this........

=SUBTOTAL(9,OFFSET($B$4,{0;1452;2904}+(ROW()-ROW($C$4))*12,0,12))

[John Vieren]

Hi,

This allready the formula am using.

However, by trial and error I added sum in front and made it into an array formula and it seems to be working.

Regards JV

[arlu1201]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.