You probably want

=SUMPRODUCT(--(Range1=200601),--(Range2<1000),--(Range2<2534),--(Range2<7
486),Range3,Range4)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Chad" wrote in message
...
Hello all. I am having a problem witha sum product formula. I have
Mulitple
Conditions and have to use the + sign to include all of them. Hereis an
example of my formula:


=Sumproduct((Range1=200601)*((Range2<1000)+(Range 2<2534)+(Range2<7486))*(
Range3)*(Range4))

This formula returns a value but it is much higher than it should be. I
have read places about possbily using an array inside myformula to help
take
care of this but I have not had any luck yet.

Any help you can provide would be greatly appreciated.

Thanks,
Chad