Having your workbook designed more database-like will work better. The current design is suspiciously like to any bookkeeping ledger from 1800+.
In attached example, you find 2 different formulas to calculate yearly amounts. The first works only, when year numbers in table don't have any gaps. The second one needs an additional helper column (RowNo, which can be hidden), and it allows gaps in year numbers.
|