IMSUM 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
- Examples of using
IMSUMformula not working?
- Similar formulas to
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.
ExamplesHere are a few example use cases that explain how to use the
IMSUM formula in Google Sheets.
Add two complex numbers
IMSUM to add two complex numbers together, represented in the standard a + bi format.
Add a range of complex numbers
IMSUM to add a range of cells containing complex numbers.
Calculate the total impedance of a circuit
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
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
IMSUM to calculate the total inductance of a series circuit, where each inductor is represented as a complex number.
IMSUM not working? Here are some common mistakes people make when using the
IMSUM Google Sheets Formula:
Providing non-complex 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.
The following functions are similar to
IMSUM or are often used with it in a formula:
IMPRODUCTfunction 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.
You can learn more about the
IMSUM Google Sheets function on Google Support.