sum column containing both text and numbers
I need a formula that will sum a column that contains both text and numbers.
The text and numbers appear in this column as the result of an if formula (if
value returned 0, "-", [value]). Can I sum a column containing mixed
information?
|