| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of constant decrement
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do decrement a value in excel | Excel Discussion (Misc queries) | |||
| if you drag the fill handle will it decrement the series | Excel Discussion (Misc queries) | |||
| if you drag the fill handle will it decrement the series | Excel Discussion (Misc queries) | |||
| How can I automatically decrement a column in hexadecimal numbers | Excel Discussion (Misc queries) | |||
| How do I increment or decrement values in a column? | New Users to Excel | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
