How to use the Excel SERIESSUM function

The SERIESSUM function is one of the math and trigonometry functions. It is used to return the sum of a power series. based on the following power series expansion:

Syntax: =SERIESSUM( xnmcoefficients )

The SERIESSUM function syntax has the following arguments:

x The input value to the power series.
n The first power to which x is to be raised.
m The step size that n is increased by, on each successive power of x.
coefficients An array of coefficients that multiply each successive power of x.

Example: Let’s look at some Excel SERIESSUM function examples and explore how to use the SERIESSUM function as a worksheet function in Microsoft Excel:

In the spreadsheet below, the Excel Seriessum function is used to calculate the power series:

Syntax:  =SERIESSUM(5,1,1,{1,1,1,1,1})


Based on the Excel spreadsheet above, the following SERIESSUM examples would return:

Syntax: =SERIESSUM(7,1,1,{1,1,1,1,1})
Result: 19607

Syntax: =SERIESSUM(12,1,1,{1,1,1,1,1})
Result: 271452

Syntax: =SERIESSUM(2,1,2,{1,2,3,4,5})
Result: 3186

Syntax: =SERIESSUM(4,1,3,{1,3,5,7,9})
Result: 611402500

Syntax: =SERIESSUM(3,1,4,{1,2,3,4,5})
Result: 652137645

Syntax: =SERIESSUM(3,1,1,{1,1,1,1})
Result: 120

Syntax: =SERIESSUM(6,1,2,{1,2,3,4})
Result: 1143510

Syntax: =SERIESSUM(2,1,3,{1,1,1,1})
Result: 1170

Syntax: =SERIESSUM(3,1,1,{1,2,3,4})
Result: 426

Note: If any argument is nonnumeric, SERIESSUM returns the #VALUE! error value.

Add a Comment

Your email address will not be published. Required fields are marked *