Increase sumif range by 3 with drag down

[Risto85]

Hi

I have SUMIF formula =SUMIF($K:$K;$H$6;L:L). What I would like is that if I drag it down the sum range will be increased by 3. So it would look like this:


SUMIF($K:$K;$H$6;L:L)
SUMIF($K:$K;$H$6;O:O)
SUMIF($K:$K;$H$6;R:R)
SUMIF($K:$K;$H$6;U:U)
...

[XOR LX]

Hi,

In your first row and drag down:

=SUMIF($K:$K,$H$6,INDEX(L:XFD,,3*(ROWS($1:1)-1)+1))

Regards

[Risto85]

Thank you XOR LX! Perfect!

[XOR LX]

You're welcome.