What is IMSUM function in Excel?
The IMSUM function is one of the ENGINEERING functions of Excel.
It Returns the sum of complex numbers.
We can find this function in ENGINEERING category of insert function Tab.
How to use IMSUM function in excel
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select ENGINEERING category.
5. Select IMSUM function
6. Then select ok.
7. In the function arguments Tab you will see IMSUM function.
8. Inumber1: inumber1,inumber2,… are from 1 to 255 complex numbers to add.
9. You will see the results in the formula result section.
Examples of IMSUM function in Excel
IMSUM related function
- Use IMREAL function to return the real coefficient of a complex number.
- Use IMAGINARY function to return the imaginary coefficient of a complex number.
- Use IMPRODUCT function to return the product of 1 to 255 complex numbers.
- Use SUM function to add all the numbers in a range of cells.
