=SUMPRODUCT(--(rng1="value1"),--(MONTH(rng2)=9),rng3)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Chris Harman" <Chris wrote in message
...
Is it possible to have 2 criteria's within sum if function

i.e. I wish to pickup A calendar month and a particular fault description.

Thanks,