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


" wrote:

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