easier sumif forumla

[bjbboats]

hi all,

I'm wanting to add up 4 week data every week but need an easy way to adjust the data every week so it pulls in the latest 4 week data.

The way I am currently doing it is setting up formulas that add the 4 week data using sumifs similar to this:

=SUMIFS(Data!x115:x167,Data!$T$115:$T$167,Data!$BJ$4)+SUMIFS(Data!x115:x167,Data!$T$115:$T$167,Data!$BJ$5)+SUMIFS(Data!x115:x167,Data!$T$115:$T$167,Data!$BJ$6)+SUMIFS(Data!x115:x167,Data!$T$115:$T$167,Data!$BJ$7)

It looks at the first column which is the week number and the last part of the formula is the current week and 1-, 2- and 3- the current week.

is there a more compact way of doing this formula? Unfortunately I have to repeat it many times!!

Thanks for any help!

[NeedForExcel]

Can you attach your sample workbook?