Hi,

Try this formula for 2009. C5 has 1,500 and C6 has 15. In D5:D7, enter
2009, 2010 and 2011. In E5, enter
=SUMPRODUCT((C5-(C6*{0,1,2,3,4,5,6,7,8,9,10,11}))). In E6, enter
=SUMPRODUCT((($C$5-(11*$C$6*(D6-$D$5)))-($C$6*{0,1,2,3,4,5,6,7,8,9,10,11}))).
You can now copy this down to cell E7

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"JV" wrote in message
...
Hello,

Is there a formula which could answer the following?

Monthly deduction is $1,500 in January of 2009 and drops by $15 per month.
What are the totals for 2009, 2010 and 2011?

Thanks in advance for the help.