Re: Sum of constant decrement

Tech-Archive recommends: Fix windows errors by optimizing your registry

w/o using SUMPRODUCT and using formula for sum of arithmetic
progression you might use the following:

A1=100000
A2=1500
A3=15
A4=12 (or number of months generally)

=A4*(2*(A1-A2)-(A4-1)*A3)/2

HIH


On 7 Maj, 07:56, JV <J...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
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.

.

Relevant Pages

  • Re: Rounding Issues
    ... Mark showed you that when he showed the last SUMPRODUCT formula. ... which sums only those amounts greater than 10. ... ditch SUMIF. ... Say you only wanted to sum the ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Wildcard with sumif
    ... Bob Phillips explains =sumproduct() in much more detail here: ... In column G I've got a list of the unique name values and I need to sum the ... amount of effort corresponding to completed tasks for each name. ... "fractallinda" wrote: ...
    (microsoft.public.excel.misc)
  • Re: Explanation of SUMPRODUCT
    ... I don't even think you need to enter it as an array ... Yes, we know this, but in this case SUM is an array formula SUMPRODUCT ... > each element is the number of times the corresponding cell value appears ...
    (microsoft.public.excel.programming)
  • Re: Conditional sumproduct?
    ... You could solve this with Sumproduct, but I would be more inclined to ... Now create the Pivot Table ... Drag Day to the Column area, Drag Week to the Row Area, Drag Project ... > In the first cell I only want the sum of projects done on Monday, ...
    (microsoft.public.excel.newusers)
  • Re: Nested SUMIF?
    ... Bob Phillips explains =sumproduct() in much more detail here: ... In a separte sheet im trying to sum up data from this table depending ... I can't seem to get DPRODUCT to work as of the way my spreadsheet is ... So is there a way to use SUMIF in a nested way? ...
    (microsoft.public.excel)