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...

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)Arvi Laanemets<(E-Mail Removed)> wrote in messagenews:(E-Mail Removed)...> 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...>