You may find it easier to use SUMPRODUCT, rather than SUMIF.
--
David Biddulph

"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