I have a range of cells, F4:T4, that have a range of values from 1 to 100 or an X or an M in each. The M can be ignored since it is valued at 0 and Excel Sum seems to ignore the cells with letters. However, if it's not in a SUM function it will need to be tested for and set to 0 in the total. Each cell which has an X must be tested for and set at a value of 10 when doing the Sum for the range of cells. Any suggestions?