Summation given a condition

[imran khan]

Hi, i am trying to add values in a row given that when i enter a week number it sum up all the values from the start uptill that week. e.g
in the below data, i like to sum uptil 201425 and next week when i enter 201426 it should sum all from 201423 till 201426 and so on each week. i have attached a file for more details.

Thanks
201423 201424 201425 201426 201427
592.1 592.1 592.1 592.1 592.1

 

[Asheesh]

@imran khan

Use SUMIF($C$11:$R$11,"<="&E6,$C$12:$R$12) in cell E17

 

[imran khan]

Thank you Asheesh, bingo it works.

Thank you so much.

 

[Asheesh]

You welcome mate...
Just one point...make E6 an absolute reference..

 

[imran khan]

Noted....Thanks