SERIESSUM Function in Excel

SERIESSUM Function in Excel returns the sum of power series as shown below

SERIESSUM Function in Excel 1

Syntax of SERIESSUM function in Excel

SERIESSUM( x, n, m, coefficients )

 

x The input value to the power series.
n The first power to which x is to be raised.
m The value to be added with n, on each successive power of x.
coefficients coefficient of x

 

Example of SERIESSUM function in Excel

Let’s generate a series of sum of 3

 31 + 32 + 33 + 34

Formula

SERIESSUM Function in Excel 2

Result:

SERIESSUM Function in Excel 3

 

Example of SERIESSUM Function with coefficients

Let’s generate a series of sum of 3 with coefficients

 1*31 + 2*32 + 3*33 + 4*34

Formula

SERIESSUM Function in Excel 4

Result

SERIESSUM Function in Excel 5

previous-small SERIESSUM Function in Excel                                                                                                                next_small SERIESSUM Function in Excel