what if the ranges exceed 60 entries, isnt there a way to do this more
efficiently?

"Stephen" wrote:

OK, my apologies. You do need the extra brackets in the slightly different
version
=SUMPRODUCT((Range1=Criteria1)*(Range2=Criteria2)* (SumRange+SumRange2))
which is what confused me prior to posting.
But I fully accept my mistake and withdraw my faulty "correction".

"Bob Phillips" wrote in message
...
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