Article ID: 118521 - Last Review: August 16, 2005 - Revision: 1.1 WD: SUM Formula Does Not Update CorrectlyThis article was previously published under Q118521 On This PageSYMPTOMS
The SUM formula field may update incorrectly if text exists in a cell of a
row or column when using one of the following predefined formula fields:
=SUM(LEFT)
NOTE: Text is considered to be any non-number character, including a
footnote reference mark.
=SUM(RIGHT) =SUM(BELOW) =SUM(ABOVE) In the following table, the first and second rows will update correctly. If the text is in a cell immediately adjacent to the formula, the calculation updates correctly. --------------------------------------------------------- | 1 | 2 | 3 | =SUM(LEFT) | --------------------------------------------------------- | 1 | 2 | TEXT | =SUM(LEFT) | --------------------------------------------------------- | 1 | TEXT | 3 | =SUM(LEFT) | --------------------------------------------------------- --------------------------------------------------------- | 1 | 2 | 3 | 6 | --------------------------------------------------------- | 1 | 2 | TEXT | 3 | --------------------------------------------------------- | 1 | TEXT | 3 | 3 | --------------------------------------------------------- WORKAROUND
To work around this problem, use either of the following methods.
Method 1Specify a range of cells in your formula, for example:
{=sum(a1:a3)}
Method 2Specify a series of cells in your formula, for example:
{=sum(a1,a2,a3)}
APPLIES TO
| Article Translations
|
| United States | Change | | | All Microsoft Sites |
Back to the top
|
