SUMIFS that skip columns

[LogerM]

I have a workbook with multiple sheets. In the main sheet, I have to output SUMIFS according to the scheme:

Please Login or Register  to view this content.

in next sheet formula should look like:

Please Login or Register  to view this content.

next:

Please Login or Register  to view this content.

and so on. So I have to jump 3 columns in the data sheet every time I copy a formula to the next column And so about 100 times. I've read a lot of threads already, but still can't get the formula to skip the columns properly. Anyone have an idea how to solve this?

[Kaper]

use

Please Login or Register  to view this content.

English version:

Please Login or Register  to view this content.

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

[JohnTopley]

Try

Please Login or Register  to view this content.

[wk9128]

Formula