Thanks, but it sums the total for that asset. I would like the formula to calculate the accumulate depreciation for a up to a given year. So in my attached spreadsheet if my given year is 2020/21 (Cell L1) my calculation in cell L3 should be that total of P3:S3. I hope this makes sense.