CODEWITHSUNDEEP
excelsum
João Lima
João Lima

Reputation: 55

Using the seriessum function

I'm having some trouble calculating the following expression's result in Excel

SUM(n=1 to 4) of 180/(1+0.05)^n

I read about the seriessum function, but I think this function is not able to apply the required step to the denominator. Could someone please suggest another solution?

Upvotes: 0

Views: 668

Answers (2)

user4039065
user4039065

Reputation:

You need an extra layer of processing, either an array formula or array processing with a SUMPRODUCT function wrapper.

The standard formula model is:

=SUMPRODUCT(180/(1+0.05)^ROW(1:4))

The array formula model is:

=SUM(180/(1+0.05)^ROW(1:4))

Array formulas need to be finalized with Ctrl+Shift+Enter↵. If entered correctly, your results should be similar to the following.

      SUMSERIES formula

Upvotes: 2

Gary's Student
Gary's Student

Reputation: 96763

In A1 enter:

=180/(1.05)^ROW()

and copy down to A4

then in B1 enter:

=SUM(A:A)

enter image description here

Upvotes: 1

Related Questions