Also, your column D, is that to be Year or Year's until next replacement?

"Eduardo" wrote:

Ok
First name the column that have the year until next replaced and another one
for the future replacement cost then

lets say that you have the information in the columns as follow starting in
row 2 with the information
Current Cost to replace Column A
last year replaced Column B
Life expected column c
Year until next replaced column D
Future replacement cost column E
2009 here enter the formula as follow
=SUMPRODUCT(--(Year_until_next_replaced=F1),Future_replacement_c ost)
2010
2011
2012
Copy that formula all over the years where you need it, and it will
summarize the totals per year from column F up to ......

"Tony" wrote:

I have a replacement reserve schedule that has the following information in
Columns €“ Current cost to replace, last year replaced, life of item (years),
Due for replacement, Year until next replaced, Future replacement cost and
each future year (now for the next 35 years). I have created a formula (IF /
THEN) that places the future replacement cost into to correct year. This
only works for the first year, but not any additional years, i.e. if the item
needs to be replaced every 4 years. Any thoughts on a formula I could use?