Hold on there a second.......

In column A I have the month and Year "Nov-06".

If you have dates like Nov-06 how do you know what day of the month that is?

If I type in Nov-06 Excel evaluates it as Nov 6 2006 not Nov 2006

Seems to me that you should use the full date.

Biff

"Biff" wrote in message
...
Try this:

=SUMPRODUCT(--(ISNUMBER(A1:A10)),--(DAY(A1:A10)<12),C1:C10)

Biff

"Raj" wrote in message
...
I am new to using formulas in Excel and need some help with using SumIf
and a
date.
In column A I have the month and Year "Nov-06". I would like to do is
have
Column C Sum only if the current day is < 12 of the month.
Thanks