You reckon?

--
HTH

Bob

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

"Stephen" <none wrote in message
...
To do it this way you would need brackets around the SumRanges:
=SUMPRODUCT(--(Range1=Criteria1),--(Range2=Criteria2),(SumRange+SumRange2))
Otherwise the criteria would apply only to SumRange and you would add in
all of SumRange2


"Bob Phillips" wrote in message
...
correction, that should be

=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