View Single Post
  #1   Report Post  
Scoosh
 
Posts: n/a
Default I think its a sumproduct query?

Top of the day to you,
I have a list of dates over several years (A column)
Debts accrued during those years (B Column)
I'd like to sum the total debts over a specific period of years from the
current year, under its respective heading, i.e. debts accrued 1-3 years from
the current year, 4-5yrs, 6-10yrs etc.
I'd need it to remain fairly dynamic that next and following years it will
recalculate from the new year.

Thanks a bundle.