sum last x weeks data based on current week

[blue sky]

I have Week Numbers in Column A and values in Column B. I would like to be able to Sum the last x weeks of data in Column B based on the current week number.

How best to do this? Thanks!

 

[FormR]

Hi, something like this maybe:

Excel 2013
	A	B	C	D	E
1	Week	Value
2	10	5
3	11	1		Current Week	21
4	12	4		Previous X weeks	5
5	13	5		Result	38
6	14	6
7	15	2
8	16	5
9	17	9
10	18	2
11	19	10
12	20	10
13	21	7
14	22	8
15	23	8
16	24	9
Sheet1

Cell Formulas
Range	Formula
E3	=WEEKNUM(TODAY())
E5	=SUMIFS(B:B,A:A,">"&E3-E4,A:A,"<="&E3)

 

[blue sky]

Perfect!! I am SO grateful!