# How to Use IMSUM in Google Sheets in 2020?

IMSUMReturns the sum of a series of complex numbers or cells or both.

Sample Usage

IMSUM(A2:A100)

IMSUM(“1+2i”,3,”4i”)

IMSUM(“1+2i”,”3+5i”,A2:A50)

Syntax

IMSUM(value1, [value2, …])

value1 – The first complex number or range to add together.
value2, … – [ OPTIONAL ] – More complex numbers or ranges to add to value1.

Notes

The sum of two complex numbers is defined as follows:

(a+bi) + (c+di) = (a+c) + (b+d)i

You can sum complex numbers only if they have the same suffix (i or j). For example, you can’t do IMSUM(“4+3i”, “1+2j”).

COMPLEX: The COMPLEX function creates a complex number, given real and imaginary coefficients.
IMREAL: Returns the real coefficient of a complex number.
IMAGINARY: Returns the imaginary coefficient of a complex number.
IMSUB: Returns the difference between two complex numbers.
IMPRODUCT: Returns the result of multiplying a series of complex numbers together.

Examples

1
A
B

2
Formula
Result

3
=IMSUM(“1+2i”, “3+4i”)
4+6i

4
=IMSUM(“20+5j”, 4, “j”)
24+6j

5
=IMSUM(COMPLEX(2, 5), COMPLEX(4, 2))
6+7i

Categories Uncategorized Tags