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