Change sum value horizontally

Hello dear forum users,

Can you help me to solve this kind of problem: I have data of 1717 groups arranged horizontally. I have another sheet that sums up that data with sumifs formula. I currently have formula for 100 groups and want to expand it easily, but for that I have to change formula so, that when I drag formula vertically, its sum range changed horizontally after 5 columns. Is there any solution for this?

little example:

=SUMIFS($F:$F,$A:$A,D$2)

=SUMIFS($K:$K,D$2)

=SUMIFS($P:$P,$A:$A,D$2)

???

???

Hi, check. First formula and copy down

Please Login or Register  to view this content.

Greetings.