Thanks for the replies!

I finally got it going by using Bob's code as a starting point.

Thanks again for all the replies,
CW

"Bob Phillips" wrote:

No, use SUMPRODUCT

=SUMPRODUCT(--(MONTH(date_range)=1),--(date_range<""),amount_range)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Cheese_whiz" wrote in message
...
Hi all,

I have a range of dates I'm using for the first argument in a sumif
function. I need to convert those dates to a single month number (one for
each date) prior to running the criteria check found in the second
argument
of the sumif function.

Is that possible?

tahnks,
CW