You're welcome. That frequently happens (where you figure out the answer
right after you post. Or you remember some more information that you should
have included in the post.)

--
Kevin Vaughn


"cbuck" wrote:

You were right - I found that out right after I posted.

Thanks!

"Kevin Vaughn" wrote:

Use the sum function. It will ignore text values and sum just the numbers.
If there are errors though, it will return the error value.
--
Kevin Vaughn


"cbuck" wrote:

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?