SUMIF in two different sheet

[sajnica89bg]

Here is a very simplified example, and my question is:

Is there an elegant solution to copy formula in sheet 1 from rows under 2014 column to 2015 column because it is the same logic, but somehow automatically to change (range) from 2014 to 2015 (without manually changing it row by row) and moreover for example if (sum_range) is not in the same column also changing it(in other example.xlsx) :D

Maybe there is a way to group data into one sheet but however I would still need to translate formula and within that to change (sum_range) from one column to the other (for example from '2014'!D:D to '2014'!J:J) without changing other element of the formula...

I hope that someone will understand me :D

[Jonmo1]

You can use INDIRECT for that..

IN Sheet1, E9

=SUMIF(INDIRECT("'" & E$8 & "'!C7:C9"),1,INDIRECT("'" & E$8 & "'!D7:D9"))