Saved Bookmarks
| 1. |
Solve : Excel function help? |
|
Answer» What is the excel function that allows me to sum cells EVEN if there is a non-number value in one of the cells? i want to sum a group of cells and some cells don't have a number, rather they have just a dash "-" in them. i used to remember that function to do that but alas, i have forgotten. any help?? thanks.What version of Excel are you using? With my Excel 2003, the SUM function automatically ignores cells with non-number content and just adds the cells with numbers.i'm using excel 2003 ALSO. darn. i THINK it has something to do with the datafeed i'm pulling from (reuters financials) i'll call them to figure how to eliminate the "__" from downloads. |
|