Hi


=SUMPRODUCT(--(Sheet2!$G$2:$G$65536=$G$7),--(Sheet2!$L$2:$L$65536=1000),--(Sheet2!$L$2:$L$65536<2000),--(Sheet2!$E$2:$E$65536="BA"),Sheet1!$M$2:$M$65536)A rvi wrote in oglegroups.com... yo! goddessez & godz! if you know SUMPRODUCT i hope that you can help out a hapless mortal... =SUMPRODUCT(--(Sheet2!$G$2:$G$65536=$G$7),--(Sheet2!$L$2:$L $65536=?????),--(Sheet2! ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ $E$2:$E$65536="BA"),Sheet1!$M$2:$M$65536) Basically for collumn L, i am trying to ask for all values from 1000-1999. How do I do this? Mucho Danke...