What does Microsoft explain?

Microsoft's SUM function guidance states that SUM ignores text values in referenced cells and sums numeric values. An apparent number in a schedule therefore needs its actual cell type checked when the total seems incomplete.

Returnables Agency is independent and is not affiliated with Microsoft. This guide concerns numeric fields in a tender workbook; it does not mean every digit-only entry should become a number. Item identifiers, leading zeros and reference codes may intentionally be text.

Sources: Microsoft: Microsoft: official reference checked 22 October 2026

Which checks belong before submission?

Review the purpose of the column before changing its contents. Keep a copy of the received workbook and work within the tender's permitted editing rules.

Which checks belong before submission?
CheckRecordReason
Field purposeQuantity, amount or identifierShould it be numeric?
Cell typeActual value representationWill the formula include it?
Formula rangeReferenced rowsIs the intended scope covered?
ReconciliationIndependent line checkDoes the total make sense?
CorrectionApproved change and before-imageCan it be traced?
Final fileSaved submission versionWas the correction retained?

How can a plausible total still be incomplete?

Illustrative example. A fictional quantity column has numeric 12, text "8" and numeric 5. SUM over those cells returns 17; the intended numeric quantities would total 25. The result 17 is a valid calculation over the stored numeric cells, but it is not the intended quantity total.

The reviewer confirms that the second field is genuinely a quantity, records its original form and follows the approved correction process. If it were item code 008, converting it to a quantity would instead damage the meaning. Do not apply a blanket conversion to the workbook.

What should be checked after a correction?

Recalculate and reconcile the affected totals, review linked outputs and inspect the final saved response. Cell display formatting alone is not evidence that the underlying value and formula coverage now match the requirement.

Keep this issue separate from stale calculated results, hidden rows and missing formula ranges. Those can also affect a submission and need their own checks; resolving the text type does not prove the rest of the workbook is correct.

Common questions

What else should the bid team know?

Does a plausible total prove every visible entry was included?

No. Check the referenced values and cell types.

Should tender reference codes be converted to numbers?

No. Preserve intentional identifiers and leading zeros.

Does changing appearance alone verify the correction?

No. Recheck the underlying value and resulting calculation.

Primary sources

  1. Microsoft: official reference checked 22 October 2026Microsoft