Hello,

I have a column which contains currency ($) and dates "mm/dd/yyyy". I'm trying to sum the values that are not a date. I understand excel stores dates a numbers, and some of the dollar value amounts are in tens of thousands that is why this formula which i found on the forum will not work all the time.

=+SUMIF(C3:C46,"<"&30000,C3:C46)

here is a small sample of the column data i'm working with:

1/31/2014
$20,000
2/20/2014
$30,000
$50,000

i'm wondering if their is a test i can do on the cell first to see if it contains any slashes "/" and if not then do a sumif? Any ideas?

Appreicate any help, thanks everyone/anyone