IMSUM

Returns 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") .

See also

• 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