summing a row with text in some cells
I am trying to sum a row, but some cells have text that explain why the data
is missing. I would like any text to be summed as zeros, but I can't seem to
figure out how to make excel do that. Any information you could give me
would be appreciated.
|