a second call for the goddezzez and godz of SUMPRODUCT

[sexynumbers]

....i think my first post must have been lost down the rabbit hole...

I have this function:

=SUMPRODUCT(--(Sheet1!$G$2:$G$65536=$E$7),--(Sheet1!$L$2:$L
$65536= ? ? ?),Sheet1!$M$2:$M$65536)

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Column L is full of numbers from 0 to 9999, the second expression in
the formula needs to call up all numbers in Column L from 1 to 3999
ONLY. . . oh, ye who are so powerful, this mortal requests the
correct syntax...

if you please...

T H A N K S !

 

[Roger Govier]

Hi

Try
=SUMPRODUCT(--(Sheet1!$G$2:$G$65536=$E$7),
--(Sheet1!$L$2:$L$65536>=1),
--(Sheet1!$L$2:$L$65536<=3999),
Sheet1!$M$2:$M$65536)

 

[Guest]

Try this:

=SUMPRODUCT(--(Sheet1!$G$2:$G$65536=$E$7),--(Sheet1!$L$2:$L$65536>=1),--(Sheet1!$L$2:$L$65536<=3999),Sheet1!$M$2:$M$65536)

HTH,
Elkar