IMSUM Function
Adds complex numbers.
Category
Engineering
Available in
All versions, Microsoft 365
Returns
Complex number text
Want to practice IMSUM 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
IMSUM adds the real parts together and the imaginary parts together. It takes up to 255 values or ranges, so it can total a whole column.
The result is text, shown to 15 significant digits. Wrap it in IMREAL or IMAGINARY to get a number you can format or round.
Syntax
=IMSUM(inumber1, [inumber2], …)
Arguments
| Argument | Required? | What it does |
|---|---|---|
| inumber1 | Yes | A complex number, or a range of them. |
| inumber2, … | No | More complex numbers or ranges. Empty cells are skipped. |
Examples
Example 1 — Add two values
Each row adds column A and column B.
C2fx=IMSUM(A2,B2)
| A | B | C | |
|---|---|---|---|
| 1 | First | Second | Sum |
| 2 | 3+4i | 5-3i | 8+i |
| 3 | 1+2i | -1-2i | 0 |
| 4 | 2.5i | 1 | 1+2.5i |
=IMSUM(A2,B2) Explain
Example 2 — Impedances in series
Components in series add up. Total the column with one range.
B2fx=IMSUM(A2:A4)
| A | B | |
|---|---|---|
| 1 | Impedance (Ω) | Total |
| 2 | 10+5j | 45+3j |
| 3 | 20-8j | |
| 4 | 15+6j |
=IMSUM(A2:A4) Explain
Common mistakes
- #NUM! The text isn't a valid complex number — for example a space ("3 + 4i"), a capital I, or a letter other than i or j.
- Using SUM. SUM ignores text, so it returns 0 for complex numbers. Always use IMSUM.
Notes

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.