Week cumulative

[beneesetas14]

Kindly requesting for the help to solve the issue


i like to do subtotal according to week


week value

1jan-3 jan 35
4jan-1jan 35
11jan-17jan 36
18jan-24jan 40
25jan-21jan 38

in another column i used data validation ( list ) of week

so once i select any week, i need to calculate the value upto that week, from the begining. evaluate the week of cell I3, with B4 : B15 ,

find the week in I3 in B4:B15 and calculate the value upto that week


example : if i select week 18jan -24jan,, i need to get the result of 35+35+36+40

[Kaper]

use either SUMIF or INDIRECT
if still in doubt - read forum rules how to post the attachment