SUMIFS that skip columns

use

Formula:

=SUMA.WARUNKÓW(PRZESUNIĘCIE('06PAZK'!C:C;0;(ARKUSZ(A1)-1)*3);PRZESUNIĘCIE('06PAZK'!B:B;0;(ARKUSZ(A1)-1)*3);A3;PRZESUNIĘCIE('06PAZK'!A:A;0;(ARKUSZ(A1)-1)*3);A1)

English version:

Formula:

=SUMIFS(OFFSET('06PAZK'!C:C,0,(SHEET(A1)-1)*3),OFFSET('06PAZK'!B:B,0,(SHEET(A1)-1)*3),A3,OFFSET('06PAZK'!A:A,0,(SHEET(A1)-1)*3),A1)

It assumes that data is the last seet (and the sheets with formulas starts with the leftmost tab (first sheet). If that is not the case, change -1 to appropriate velue (appears 3 times in the formula)

See tha attachmet

Try

Formula:

=SUMIFS(INDEX('06pazk'!$C:$XFD,,(COLUMN(A1)-1)*3+1),INDEX('06pazk'!$B:$XFD,,(COLUMN(A1)-1)*3+1),$A$3,INDEX('06pazk'!$A:$A,,(COLUMN(A1)-1)*3+1),$A$1)