Do you mean that the dates are month name strings? If so it would just be

=SUMPRODUCT((A1:A100="condition1")*(B1:B100="Octob er")=10),(C1:C100))
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

wrote in message
...
What it does not seem to want to take is a "range" of
months.??
-----Original Message-----
Try SUMPRODUCT

=SUMPRODUCT((A1:A100="condition1")*(MONTH(B1:B100 )=10),
(C1:C100))

will sum just October plus your other condition

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"D.Meconi" wrote in
message
...
I do not have the"wizzard" so...I am trying to write a
formula to SUMIF: One collumn meets a certain critera,I
sum another collumn...no problem, however, I need
another
condition, only if a third collumn is a specific date.
How
can I write it to look at a collumn (range) for a
specific
MONTH?
Any ideas?


.