SUM by week

[Skybluekid]

Hi All,

I have a sheet that has data as follows

Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

Data 60 62 52 42 42 78 75 79 80 50 61 66 72 79 23 8 8

What I need is to sum the range according to the week number. For example, If it is week 14, I would like to sum the range upto an including that week. But I would like to be done automatic so that when the week changes the sum range will automatically update to that week.

Thanks in advance

 

[Snakehips]

Skybluekid,

Perhaps something like this....

Excel 2007
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	SUM	921
2
3	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17
4	60	62	52	42	42	78	75	79	80	50	61	66	72	79	23	8	8
Sheet1

Cell Formulas
Range	Formula
B1	=SUMIF($A$3:$AZ$3,"<="&WEEKNUM(TODAY()),$A$4:$AZ$4)

Alter the ranges to suit. If your week numbers are not strickly in line with the weeks of the year then you can add a + or - adjustment to the formula.

Hope that helps.

 

[Akashwani]

Hi,

Does this work?....

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Week	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17
2	Data	60	62	52	42	42	78	75	79	80	50	61	66	72	79	23	8	8
3
4
5	Week	14
6	Result	898
7
Sheet3

I hope that helps.

Ak

 

[Skybluekid]

Thanks, it works a treat. The coventry boys do it again!