Microsoft KB Archive/24561

Adding Cells That Contain Text PSS ID Number: Q24561 Article last modified on 08-26-1987 PSS database name: D_MPlan

3.0 3.01 3.02

MS-DOS

Question: I have a formula that adds cells together. One of the cells has text in it, and I keep getting the #Value! error in the cell with the formula. Can a formula to add cells be entered in a way that will view the cell with the text as zero?

Response: Yes. The Sum function will overlook the text, whereas the + (plus character) will not. Change the formula so it uses the Sum function to add the cells together, instead of adding them with the plus sign.

Copyright Microsoft Corporation 1987.