=SUMPRODUCT(...) + SUMPRODUCT(...)

make the criteria the same, just use different ranges.
--
Gary''s Student - gsnu200752


"Gwynneth" wrote:

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