try

=SUMPRODUCT(($G$2:$G$800=J8)*($E$2:$E$800<"NJ")*( $F$2:$F$800<"FL")*($F$2:$F$800<"NJ")*($D$2:$D$80 0))

Mike

"tmwilkin" wrote:

I know how to work a sumproduct where you're trying to include multiple
values in an array, but how do you exclude multiple values.

Below is the formula I am currently using:
=SUMPRODUCT(--($G$2:$G$8000=J8),--($E$2:$E$8000<"NJ"),--($F$2:$F$8000<"FL"),--($D$2:$D$8000))

I need the ($F$2:$F$8000<"FL") to also be < to "NJ" too.

Any help would be greatly appreciated. Thanks!