Using offset or other function that takes values of each third column for example

[moty.98]

Hi,

I'd like to know how I can get the requested result in the attached sheet using formula. When I try to drag the formula, it doesn't work off course, because it occurs only on tripplets.


Thank you,

Moty

[Jonmo1]

Try this in Q4 and filled right

=SUMIF($A$3:$L$3,Q$3,$A$5:$L$5)

[Jonmo1]

You need formulas for both row 4 and 5

Q4: =SUMIF($A$3:$J$3,Q$3,$A$5:$J$5)
Q5: =IF(Q4>9,SUMIF($A$3:$J$3,Q$3,$C$5:$L$5)/SUMIF($A$3:$J$3,Q$3,$B$5:$K$5),"")

Fill both Right

[martindwilson]

here is one way