SERIESSUM Function

Returns the sum of a power series.

Category

Math & Trig

Available in

All versions, Microsoft 365

Returns

A number

Want to practice SERIESSUM in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

SERIESSUM adds up a₁xⁿ + a₂xⁿ⁺ᵐ + a₃xⁿ⁺²ᵐ + … for the coefficients you give it.

It's used in engineering and to approximate functions like eˣ or sin x.

Syntax

=SERIESSUM(x, n, m, coefficients) Explain

Arguments

ArgumentRequired?What it does
xYesThe input value.
nYesThe first power.
mYesHow much the power increases each term.
coefficientsYesThe multipliers a₁, a₂, a₃…

Examples

Example 1 — A simple series

2·x⁰ + 3·x¹ + 4·x² with x = 2: 2 + 6 + 16.

B2fx=SERIESSUM(2, 0, 1, A2:A4)
AB
1CoefficientSum
2224
33
44
=SERIESSUM(2, 0, 1, A2:A4) Explain

Common mistakes

  • Text coefficients. Return #VALUE!.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.