Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Use Excel IMSUM Function (4 Easy Examples)

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.


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.

Dataset of Using Excel IMSUM Function

  • Next, insert the following formula in the D5 cell.
=IMSUM(B5,C5)

Insert Formula of Using Excel IMSUM Function

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

Fill Handle of Using Excel IMSUM Function

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

Result of Using Excel IMSUM Function

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.

Dataset of Using Excel IMSUM Function

  • Then, insert the following formula in the D5 cell.
=IMSUM(B5,C5)

Insert Fomula of Using Excel IMSUM Function

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

Fill Handle of Using Excel IMSUM Function

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

Dataset of Using Excel IMSUM Function

  • Subsequently, insert the following formula in the E5 cell.
=IMSUM(B5,C5,D5)

Inserting Formula

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


Related Articles

Zehad Rian Jim

Zehad Rian Jim

Hi there! I am Zehad Rian Jim. I graduated with a bachelor's degree in engineering from BUET. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include watching movies, tv series, and meeting new people. I also enjoy sports. My favorite sports are Cricket (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo