IMSUM in Excel: Add Complex Components and Verify Weighted Totals

• Introduced: the first introduction version is not established by the reviewed official history.
• Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
• Checked: October 14, 2026; official IMSUM reference. Documentation and independent models; no native Excel execution or wider platform certification.

=IMSUM(inumber1,[inumber2],...)

The first argument is required; later arguments are optional. Microsoft explicitly states one to 255 complex numbers in the argument section. A single-input control therefore has the same complex quantity as that input.

The reference describes i or j complex notation and recommends COMPLEX for numeric coefficients. These examples use explicit scalar arguments and cell references. The dedicated page does not establish a complete range, blank, error or mixed-type aggregation matrix, so no such policy is inferred from ordinary SUM.

Use a consistent imaginary suffix when combining values. The separate COMPLEX reference states that complex functions with multiple complex arguments require matching suffixes. This guide does not assign a native error code to every mismatch.

Enter the exact text strings 4+3i, -2+6i and 5-i in A2:A4. In B2 use:

=IMSUM(A2,A3,A4)

Expected result: 7+8i. The real total is 4−2+5=7; the imaginary total is 3+6−1=8.

The arguments refer to three worksheet cells explicitly. The result is one complex sum, not a spilled list of the three inputs. Keeping the input cells separate makes it easy to identify which record contributes each coefficient.

For a direct two-input control, =IMSUM("4+3i","-2+6i") has expected result 2+9i. With one input, =IMSUM("4+3i") retains the quantity 4+3i under the formal argument contract.

For A2:A4, use =IMREAL(A2) in C2 and =IMAGINARY(A2) in D2, filling down. Expected real coefficients are 4, −2 and 5; imaginary coefficients are 3, 6 and −1.

=SUM(C2:C4) returns seven and =SUM(D2:D4) returns eight. Compare these with =IMREAL(B2) and =IMAGINARY(B2).

IMREAL and IMAGINARY expose the arithmetic behind the sum. Ordinary SUM is being used on numeric helper columns, not assumed to aggregate arbitrary complex text according to IMSUM’s rules.

First add A2 and A3, giving 2+9i, then add A4:

=IMSUM(IMSUM(A2,A3),A4)

The expected result remains 7+8i. Grouping A3 and A4 first gives 3+5i, then adding A2 also gives 7+8i.

This demonstrates associativity for these small exact component values. It is not a guarantee that every floating-point evaluation order produces identical last digits when inputs have very different scales.

A useful recovery check is =IMSUB(B2,A4), which returns 2+9i, the sum of the other two records. IMSUB reverses the selected contribution using an explicit two-argument subtraction.

Suppose the first record receives weight two and the second receives weight three. Use:

=IMSUM(IMPRODUCT(A2,2),IMPRODUCT(A3,3))

The scaled values are 8+6i and −6+18i, so the result is 2+24i. IMPRODUCT has an official numeric-scalar example supporting this use of real weights.

The coefficient checks are 2×4+3×(−2)=2 and 2×3+3×6=24. Weights describe the model being applied; IMSUM does not determine whether those weights are appropriate for a particular report.

For 3+4i and 3−4i, the imaginary coefficients cancel. Their sum has real coefficient six and imaginary coefficient zero. By contrast, the separate magnitudes are both five and total ten.

=IMABS(IMSUM("3+4i","3-4i")) has expected result six, while =IMABS("3+4i")+IMABS("3-4i") gives ten. IMABS measures magnitude after or before aggregation, which are different questions.

For the complete cancellation pair 4+3i and −4−3i, both summed coefficients are zero. The guide describes those numeric components rather than certifying the native TYPE of the simplified complex result.

Keep the complex source values and their coefficient checks together. A zero result can be valid cancellation; it should not automatically be used as a substitute for an invalid or missing source record.

The one-to-255 argument statement does not establish a general array-expansion limit or a policy for text embedded in a larger range. The examples deliberately use explicit scalar complex arguments.

Malformed inputs, mixed suffix errors, unpinned blank coercion and extreme precision behavior remain untested. All displayed sums were independently calculated; no native Excel execution was performed.

• Microsoft IMSUM reference.
• Editorial testing standards.

Expected outputs are independently calculated examples or documented rules, not captured native Excel results. Formulas use English function names and comma argument separators. Locale, rendering and boundary restrictions are stated where relevant.