SUMIFS with dynamic sum range

[ajm]

Friday night problem has me vexed. I am creating a report containing budget data. Trying to include data from last year's budget for the same month. How do I write a sumifs formula with a dynamic sum range. Last year's budget is in a separate tab to the report. Range on budget sheet with data to sum, including headers is S15:AD5000.

ANY HELP WOULD BE GREATLY APPRECIATED.

 

[Takae]

Sample formula
=SUM(OFFSET($A$2,0,0,COUNTA(A:A),1))

The result shows up, and add some numbers columnA, the result will change automatically.
You can put the formulra in range of a Named Range.
The formula will be "=SUM(SAMPLE_Name)"

Hope this helps.

 

[ajm]

Thanks Takae. I'll give that a crack and see what happens. Only just noticed my thread title. "Synods" was meant be "Sumifs".

 

[Takae]

You can use Named Range in Sumisf too.