This tutorial will demonstrate how to use Excel **IMSUM** Function. When we are dealing with complex numbers, we can easily add them with the help of this function. A complex number is an inseparable part of the engineering sector. Suppose we have a number like **x+iy**, in which **x **represents the real number and **y** is the coefficient of the imaginary part. Now we want to add this kind of complex number to our article. This function can be easily useful in every aspect of life where we want to use complex numbers. So, it is essential to learn how to use Excel **IMSUM** Function.

**Table of Contents**hide

## Download Practice Workbook

You can download the practice workbook from here.

**Introduction to Excel IMSUM Function**

**⦿ Summary:**

The **IMSUM function** mainly returns the sum of two or multiple complex numbers in Excel.

**⦿ Syntax:**

The syntax of the **IMSUM function** is as follows:

**=****IMSUM(inumber1, [inumber2], …)**

**⦿ Arguments:**

Argument | Required/Optional | Explanation |
---|---|---|

inumber1, [inumber2],.. |
Required | Complex values |

**⦿ Return Value:**

Returns the sum of the complex numbers for argument.

**⦿ Available in:**

Office 365 | Excel 2019 | Excel 2016 | Excel 2013 | Excel 2011 for Mac | Excel 2010 | Excel 2007 | Excel 2003 | Excel XP | Excel 2000.

## 4 Easy Examples of Using Excel IMSUM Function

We’ll use a sample dataset overview as an example in Excel to understand easily. If you follow the steps correctly, you should learn how to show the print area in excel on your own. The methods are

### 1. Adding Real and Complex Values

In this case, we have one column that consists of a real number and one column that consists of a complex number. Our goal is to learn how to use Excel **IMSUM** Function to add them. We can learn this method by following the below process.

**Steps:**

- First, we arranged a dataset like the below image. In this case, we have the
**Real Value**in**column B**and the**Complex Value**in**column C**. We want to determine the addition of these two columns in**column D**under the name of the**Result.**

- Next, insert the following formula in the
**D5 cell**.

`=IMSUM(B5,C5)`

- After that, you will get the addition of real and complex numbers for this cell using the
**IMSUM**function and then use the**Fill Handle**to apply the formula to all the cells.

- Finally, you will get the final result for this whole column. The real value
**2**and the complex value**2i**show the result of**2+2i**. In the**2+2i**number, the**2**represents the real value and the**2i**portion represents the imaginary value.

Therefore, we have used the Excel **IMSUM** Function to add real and complex values.

**Read More: ****How to Use IMAGINARY Function in Excel**

### 2. Addition of Two Complex Values

Next, we have two columns that consist of complex numbers. Our goal is to learn how to use Excel **IMSUM** Function to add these complex numbers. We can learn this method by following the below process.

**Steps:**

- To begin with, we arranged a dataset like the below image. In this case, we have the
**Complex Value 1**in**column B**and the**Complex Value 2**in**column C**. We want to determine the addition of these two columns in**column D**under the name of the**Result.**

- Then, insert the following formula in the
**D5 cell**.

`=IMSUM(B5,C5)`

- Moreover, you will get the addition of these complex numbers for this cell using the
**IMSUM**function and then use the**Fill Handle**to apply the formula to all the cells.

- Finally, you will get the final result for this whole column. The first complex value
**1+i**and the second complex value**3-2i**show the result of**4-i**. In the**4-i**number, the**4**represents the real value and the**i**portion represents the imaginary value.

Hence, we have used the Excel **IMSUM** Function to add the two complex values.

**Read More: ****How to Add Complex Numbers in Excel (With Easy Steps)**

### 3. Adding Multiple Complex Values

This time, we have multiple columns that consist of complex numbers. Our goal is to learn how to use the Excel **IMSUM** Function to add these columns of complex numbers. We can learn this method by following the below process.

**Steps:**

- First, we arranged a dataset like the below image. In this case, we have the
**Complex Value 1**in**column B, Complex Value 2**in**column C,**and**Complex Value 3**in**column D**. We want to determine the addition of these columns in**column E**under the name of the**Result.**

- Subsequently, insert the following formula in the
**E5 cell**.

`=IMSUM(B5,C5,D5)`

- As a result, you will get the addition of these complex numbers for this cell using the
**IMSUM**function and then use the**Fill Handle**to apply the formula to all the cells.

- Finally, you will get the final result for this whole column. The first complex value is
**1+i**, the second complex value**is 3-2i,**and the third complex value**8-2i**. The whole function shows the result of**12-3i**. In the**12-3i**number, the**12**represents the real value and the**3i**portion represents the imaginary value.

Moreover, we have used the Excel **IMSUM** Function to add multiple complex values.

**Read More: ****How to Get Complex Number Magnitude in Excel (2 Easy Methods)**

### 4. Combining IMSUM and IMABS Functions to Calculate Absolute Value

Now, we have two columns of complex numbers. Now, we want to determine the absolute value of the addition of these complex numbers in Excel. We can easily fulfill our goal by using the combination of the** IMSUM **and** IMABS** functions. The** IMSUM **function portion determines the addition of the two complex numbers and the **IMABS** function determines the absolute value of the addition of the complex numbers. We can learn the steps of the method by following the below steps.

**Steps:**

- First, we arranged a dataset like the below image. In this case, we have the
**Complex Value 1**in**column B**and the**Complex Value 2**in**column C**. We want to determine the addition of these two columns and then find their absolute value in**column D**under the name of the**Result.**

- In addition, insert the following formula in the
**D5 cell**.

`=IMABS(IMSUM(B5,C5))`

- Afterward, you will get the addition of the two complex numbers and then find the absolute value for this cell using the combination of the
**IMSUM**and**IMABS**functions and then use the**Fill Handle**to apply the formula to all the cells.

- Finally, you will get the final result for this whole column. The first complex value
**1+i**and the second complex value**3-2i**show the result of**4-i**with the help of the**IMSUM**Then we used the**IMABS**function to determine the absolute value for this cell which is**4.12**.

So, Hence, we have used the combination of Excel **IMSUM** and **IMABS** functions to add the two complex values and then determine their absolute value.

**Read More: ****How to Convert Complex Numbers to Polar Form in Excel**

## How to Use Excel IMSUB Function

In this last section, we have two complex numbers columns. Now, our goal is to learn how to use the Excel **IMSUB** Function to find the subtraction of these complex numbers. We can learn this method by following the below process.

**Steps:**

- At first, we arranged a dataset like an image below. In this case, we have the
**Complex Value 1**in**column B**and the**Complex Value 2**in**column C**. We want to determine the subtraction of these two columns and then find their absolute value in**column D**under the name of the**Result.**

- Now, insert the following formula in the
**D5 cell**.

`=IMSUB(B5,C5)`

- Hence, you will get the subtraction of these complex numbers for this cell using the
**IMSUB**function and then use the**Fill Handle**to apply the formula to all the cells.

- Last, you will get the final result for this whole column. The first complex value
**1+i**and the second complex value**3-2i**show the result of**-2+3i**. In the**-2+3i**number, the**-2**represents the real value and the**3i**portion represents the imaginary value.

At last, we found the subtraction of two complex numbers using the** IMSUB** function.

## Conclusion

Henceforth, we have described all the methods which will help you to use Excel **IMSUM** Function. Then, we will be glad to know if you can execute the task in any other way. Follow the **ExcelDemy** website for more articles like this. Please feel free to add comments, suggestions, or questions in the section below if you have any confusion or face any problems. We will try our best to solve the problem or work with your suggestions.