How to Use the IMSUM Function in WPS on Windows

Last updated:July 20, 2026

Use IMSUM through 4 how-to topics, including entering the function, checking syntax prompts, using cell references, and working across worksheets.

How-to Index

No.TopicMembership Requirement
11. Enter the IMSUM functionFree
22. Check the syntax prompt and fill in argumentsFree
33. Use cell references for complex-number additionFree
44. Use IMSUM across worksheetsFree

How-to Guide

1. Enter the IMSUM function

Entry: Formulas tab → Formula bar

  1. Open a spreadsheet and select the cell where you want to show the result.
  2. Type = in the cell or formula bar.
  3. Type IMSUM.
  4. Type the opening parenthesis ( to begin entering arguments.

Success Criteria

  • On-screen result: The cell enters formula editing mode.
  • Next step available: You can continue entering arguments and complete the formula.

Tips While Using

  • Common mistake: If you do not start with =, the content is treated as plain text.

2. Check the syntax prompt and fill in arguments

Entry: Formula bar

  1. After typing =IMSUM(, look at the function prompt area.
  2. Confirm the argument structure and order shown in the prompt.
  3. Enter complex-number text or the required cell references.
  4. Type the closing parenthesis ) and press Enter.

Success Criteria

  • On-screen result: The cell shows a calculated result.
  • Next step available: When you select the cell again, you can review the full formula in the formula bar.

Tips While Using

  • Common mistake: Missing parentheses or incorrect argument separation can cause a formula error.

3. Use cell references for complex-number addition

Entry: Formulas tab → Formula bar

  1. Enter complex-number values in the relevant cells.
  2. Select the result cell and type =IMSUM(.
  3. Click each cell you want to include and separate the arguments as needed.
  4. Close the parenthesis and press Enter to calculate.

Success Criteria

  • On-screen result: The result cell returns the complex-number sum.
  • Next step available: If referenced cells change, the result updates automatically.

Tips While Using

  • Common mistake: If referenced data is stored in an unexpected text format, the result may not match your expectation.

4. Use IMSUM across worksheets

Entry: Formulas tab → Formula bar

  1. In the current worksheet, select the result cell and type =IMSUM(.
  2. Switch to another worksheet and click the complex-number cell you want to reference.
  3. Return to the formula and add any remaining arguments.
  4. Close the parenthesis and press Enter to finish the cross-worksheet calculation.

Success Criteria

  • On-screen result: The formula includes worksheet reference information.
  • Next step available: When source data changes on another sheet, the result can update automatically.

Tips While Using

  • Common mistake: If a referenced worksheet or cell is removed, the formula may return a reference error.