Translations:Documentation/Calc Functions/SUM/15/en

    From The Document Foundation Wiki

    SUM ignores any text or empty cell within a range or array. If you suspect wrong results of the SUM function, look for text in the data ranges. Use the View > Value Highlighting feature to highlight the text contents in the range that may represent a number.