Sum of Arrays with multiplier

[John Vieren]

Dear All,

I have 3 arrays with 3 rows each and would like to sum each row of the 3 arrays separately.

The formula I developed uses sum with an offset and this is working.

I tried using subtotal but I can not get it to produce the correct answer.

I then tried the above with a multiplier on each array row and cannot get it to work.

The enclosed workbook will clarify the issues.

Any help much appreciated, thanks John

[John Vieren]

Hi Again,

I managed to figure out the sum method with multipliers and the result is enclosed.

However, the subtotal approach is beyond me.

Anyone have any insights?

Thanks and regards John

[samba_ravi]

f9=SUM(SUBTOTAL(9,OFFSET(D9,(ROW($1:$3)-1)*4,0)))
h9=SUM(N(OFFSET(D$8,(ROW($1:$3)-1)*4+ROW()-ROW(W$8),0,3,1))*(C$9:C$11))
i9=SUM(SUBTOTAL(9,OFFSET(D9,(ROW($1:$3)-1)*4,0))*(C$9:C$11))
All the above are array formulas confirm with Ctrl+Shift+Enter
and copy towards down