IMSUM
TheIMSUM
function returns the sum of complex numbers. It can take up to 255 complex number arguments. It is commonly used in engineering and scientific applications where complex numbers are used.
 How to use
IMSUM
formula?  Examples of using
IMSUM
formula IMSUM
formula not working? Similar formulas to
IMSUM
Usage
Use the IMSUM
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 value1 (required):
The first complex number or range of cells containing complex numbers to be added.  value2, ... (optional):
[Optional] Additional complex numbers or ranges of cells containing complex numbers to be added.
Examples
Here are a few example use cases that explain how to use theIMSUM
formula in Google Sheets.
Add two complex numbers
Use IMSUM
to add two complex numbers together, represented in the standard a + bi format.
Add a range of complex numbers
Use IMSUM
to add a range of cells containing complex numbers.
Calculate the total impedance of a circuit
Use IMSUM
to calculate the total impedance of a circuit, where each component is represented as a complex number.
Calculate the total capacitance of a circuit
Use IMSUM
to calculate the total capacitance of a parallel circuit, where each capacitor is represented as a complex number.
Calculate the total inductance of a circuit
Use IMSUM
to calculate the total inductance of a series circuit, where each inductor is represented as a complex number.
Common Mistakes
IMSUM
not working? Here are some common mistakes people make when using the IMSUM
Google Sheets Formula:
Providing noncomplex numbers as arguments
If any of the arguments provided to IMSUM are not complex numbers or references to cells containing complex numbers, the function will return an error. Make sure all arguments are valid complex numbers.
Providing more than 30 arguments
IMSUM can only accept up to 30 arguments. If you provide more than 30 arguments, the function will return an error. Remove any unnecessary arguments.
Related Formulas
The following functions are similar to IMSUM
or are often used with it in a formula:

IMPRODUCT
The
IMPRODUCT
function in Google Sheets returns the product of multiple complex numbers. It takes in one or more complex numbers as input arguments and calculates their product. Complex numbers must be entered in the format a+bi, where a is the real part and b is the imaginary part. This function is commonly used in engineering and scientific applications.
Learn More
You can learn more about the IMSUM
Google Sheets function on Google Support.