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
| Argument | Required? | What it does |
|---|---|---|
| x | Yes | The input value. |
| n | Yes | The first power. |
| m | Yes | How much the power increases each term. |
| coefficients | Yes | The 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)
| A | B | |
|---|---|---|
| 1 | Coefficient | Sum |
| 2 | 2 | 24 |
| 3 | 3 | |
| 4 | 4 |
=SERIESSUM(2, 0, 1, A2:A4) Explain
Common mistakes
- Text coefficients. Return #VALUE!.
Notes
- Related functions: SUMPRODUCT, POWER.

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.