If you put a " ' " (without the quotes - meaning a single apostrophe)
in front of the dates -- all such cells should be eliminated from your SUM()
formula...

"Stacey" wrote:

I need to use dates and numbers in the same column and total only the numbers
using a formula. Once I changed the specific cells with the dates to "text"
so that they would not be included in the sum, I can no longer sum the
numbers. The problem doesn't go away if the cells are formated to "number",
"general" etc. The sum is always "0".
--
Stacey