Try the formulas presented.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Learning Excel" wrote in message
...
Thanks for the formula Don Guillet and "Teethless mama", but I need to
adjust
it to my worsheet wich the only difference than Phendrena's is that mine
has
numbers from B1 to B30 and I need to ADD them ( not SUMPRODUCT) if A1 TO
A30
is November 2007. Thanks.
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.


"Teethless mama" wrote:

=SUMPRODUCT(--(MONTH(A2:A100)=11),--(YEAR(A2:A100)=2007),B2:B100)


"Phendrena" wrote:

I want to sum a particular range using a date range as a criteria,
I have the dates in the worksheet formatted as dd/mm/yyyy.
How do i format this in the criteria?

For example dates for November would only be included anything else
would be
ignored.

Thanks,