Summing Formula Help

[chinley]

Hi there,

I'll try explain this the best I can....

I have a list of results week by week. I want a formula that, when a given week number is entered in A1, returns the sum of that week and all the prior weeks.

For example when 4 is in A1, I want the formula to return week 1 (D2) + week 2 (E2) + week 3 (F2) + week 4 (G2)

Thanks in advance

 

[barry houdini]

Assuming your data goes as far as Z2 try this

=IF(A1=0,"",SUM(D2:INDEX(D2:Z2,A1)))

 

[chinley]

Thanks a lot!