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
Bookmarks