Related Function:

The IMSUM function returns the sum of two or more complex numbers in x + yi or x + yj text format.


=IMSUM(inumber1,[inumber2], … )


Argument Description
[inumber2], …
1 to to 255 complex numbers to add. inumber1 is required, subsequent inumbers are not

Note: Use the COMPLEX function to convert real and imaginary coefficients into a complex number.


  A B C D
1 Data Formula Result Notes
2 3+4i =ISUM(A2,A3) 5+3i Sum of two complex numbers
3 2-i =ISUM(“3+4i”,”2-i”) 5+3i  
4   =ISUM(“2-i”,3) 5-i  
5   =ISUM(“3+4i”,COMPLEX(4,1)) 7=5i  

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if the supplied inumber argument is not recognized as a complex number
#NAME? Occurs when Analysis ToolPak add-in is not enabled

When adding complex numbers a+bi and c+di, the calculation is as follows:    

    \[   (a+bi) + (c+di) = (a+c) + (b+d) i   \]

See Wikipedia for more information on complex numbers.