The IMSUM function is used to return the sum of complex numbers in the form of a + bi or a + bj.


=IMSUM(number1, number2, ...)

number1 number2 ... Complex numbers in the form of a + bi or a + bj that you want to add together.


When it comes to dealing with complex numbers in Excel, IMSUM comes to the rescue. It simplifies the process of adding up complex values if you're working in a field like electronics, physics, or mathematics that involves complex arithmetic operations. The function understands the structure of complex numbers, enabling you to effortlessly sum them up with precision and ease.

To use IMSUM effectively, enter the complex numbers you wish to add within the function. Each complex number should be in the form of 'real part + imaginary part i' or 'real part + imaginary part j'. IMSUM will then calculate the sum of these complex numbers, providing you with the resulting complex value.

An essential trait of IMSUM is its ability to handle multiple complex numbers at once. Whether you're adding two or more complex values, IMSUM streamlines the process, removing the hassle from complex arithmetic operations and delivering accurate outcomes.

In essence, IMSUM acts as an essential tool in Excel for quick and precise summation of complex numbers, catering to a diverse range of professions that deal with complex arithmetic on a regular basis.


Suppose you have complex numbers 3+2i, 1-4i, and 5+6i. You wish to find the total sum of these numbers. The IMSUM formula would be:
=IMSUM(3+2i, 1-4i, 5+6i)
This will return the sum of the complex numbers as a single complex value.

You have complex numbers 2+3j, -1+5j, and 4-2j. You want to calculate their total sum. The IMSUM formula would be:
=IMSUM(2+3j, -1+5j, 4-2j)
This formula will provide you with the sum of the specified complex numbers.


How does the IMSUM function handle multiple complex numbers?

The IMSUM function efficiently adds up multiple complex numbers provided as arguments within the function, calculating the sum of these values as a single complex number based on their real and imaginary parts.

Can I use IMSUM to add complex numbers with different formats?

Yes, IMSUM can handle complex numbers with different formats, provided they follow the standard representation of complex numbers in Excel, i.e., 'real part + imaginary part i' or 'real part + imaginary part j'. Ensure that the formats are consistent for accurate computation.

Is there a limit to the number of complex numbers that IMSUM can sum?

No, IMSUM allows you to add multiple complex numbers within a single formula, so you can sum up as many complex numbers as needed in a single calculation.

Related functions