Using the Excel IMSUM Function

Summary
The Excel IMSUM function returns the sum of two complex numbers provided in the text format of x + yi or x + yj.Use the COMPLEX function to convert real and imaginary coefficients into a complex number.
Syntax
=IMSUM (inumber1, [inumber2], ...)Syntax Breakdown
Inumber1Required. The first complex number.
Inumber2
Optional. Additional complex numbers. The function accepts from 1 to 255 values.
Usage Notes
IMSUM returns the sum of two or more complex numbers, up to 255 numbers. Arguments must be in the text format of x + yi or x + yj.Only lowercase "i" and "j" will be accepted by the function. Any other value will result in the #NUM! error.