Check Sheet Logo
Check Sheet

IMSUM

The 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.

Usage

Use the IMSUM formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:

=IMSUM(value1, [value2, ...])
Parameters:
  1. value1 (required):
    The first complex number or range of cells containing complex numbers to be added.
  2. 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 the IMSUM 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 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.

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.