"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

Just use =SUMPRODUCT(...) + SUMPRODUCT(...)
where both have the same criteria, and the first is based on SumRange and
the second on SumRange2