This is for a mileage calculation. Essentially, someone claims mileage i.e. Km done. However the rate they are entitled to is dependent on the CUMULATIVE miles they have done. e.g. in Week 2 someone has done 2250 km but because they have already done 300 in the previous week, they get paid 1200 in Band 1 (which has a cut-off of 1500) and 1050 in Band 2. And so on for the other weeks...What's required here are just the km. I can do the actual calculation with a sumproduct formula in another cell.