=SUMPRODUCT(--(J20:J100=--"1/1/6"),--(J20:J100<=--"31/1/6"),--(G20:G100="new"))

however a better way would be

=SUMPRODUCT(--(J20:J100=DATE(2006,1,1)),--(J20:J100<=DATE(2006,1,31)),--(G20:G100="new"))

since it is not region centric regarding the date format

--
Regards,

Peo Sjoblom

Portland, Oregon




"Wayne E" <Wayne wrote in message
...
I am trying to calculate how many times an event happens with multiple
criteria. As i understand it COUNTIF will not work. But SUMPRODUCT is the
way
to go. I have tried this but am unable to get to work.

I am trying to find out how many time "new" occurs in a given month say
from
1st Jan to 31st Jan so my formula read
=sumproduct((J20:J100=01/01/06),(j20:j100<=31/01/06),(g20:G100="new")
What am I doing wrong?