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.
| Check | Record | Reason |
|---|---|---|
| Field purpose | Quantity, amount or identifier | Should it be numeric? |
| Cell type | Actual value representation | Will the formula include it? |
| Formula range | Referenced rows | Is the intended scope covered? |
| Reconciliation | Independent line check | Does the total make sense? |
| Correction | Approved change and before-image | Can it be traced? |
| Final file | Saved submission version | Was 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.