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

ArgumentRequired?What it does
inumber1YesA complex number, or a range of them.
inumber2, …NoMore 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)
ABC
1FirstSecondSum
23+4i5-3i8+i
31+2i-1-2i0
42.5i11+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)
AB
1Impedance (Ω)Total
210+5j45+3j
320-8j
415+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

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.