a second call for the goddezzez and godz of SUMPRODUCT
 

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

a second call for the goddezzez and godz of SUMPRODUCT
 

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)


--
Regards
Roger Govier



wrote in message
oups.com...
...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 !

a second call for the goddezzez and godz of SUMPRODUCT
 

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 !