=sumproduct(--((Range1=Criteria1),--(Range2=Criteria2),SumRange,SumRange2))

--
HTH

Bob

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

"Gwynneth" wrote in message
...
Current format used is as follows

=sumproduct(--((Range1=Criteria1)*(Range2=Criteria2)*SumRange))

Is there a way of adding in another range to sum subject to the specifed
criteria?

Thank you in advance
--
Gwynneth