I have this function, bestowed upon me from beyond excel purgatory...


=SUMPRODUCT(--(Sheet2!$G$2:$G$65536=$E$7),--(Sheet2!$L$2:$L
$65536=1),--(Sheet2!$L$2:$L$65536<=3999),Sheet2!$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.

What if? What if... I still need 1 to 3999, but need to exclude two
numbers, 2000 and 2010 from the set?

Please, please...please....thanks for any assistance given...!