ExcelBanter - #value! error in sum function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - #value! error in sum function (https://www.excelbanter.com/excel-worksheet-functions/243687-value-error-sum-function.html)

Art

#value! error in sum function

I need to sum a range of cells. Some of the cells may contain text. If so,
the function returns #value!. In Lotus 1-2-3, text is treated as 0 for
function purposes. Is there some way to force Excel to do the same, or
another way to get around this problem?

All times are GMT +1. The time now is 10:26 PM.