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!

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!

Maybe this

=SUMPRODUCT(--($G$2:$G$8000=J8),--($E$2:$E$8000<"NJ"),--($F$2:$F$8000<"FL"),--($F$2:$F$8000<"NJ"),$D$2:$D$8000)

If you are totaling numbers in D2:D80000 then you don't need the unary
minuses for the last part


--


Regards,


Peo Sjoblom


"tmwilkin" wrote in message
...
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!

That seemed to do the trick even though it seemed like too easy of an answer.

"Peo Sjoblom" wrote:

Maybe this

=SUMPRODUCT(--($G$2:$G$8000=J8),--($E$2:$E$8000<"NJ"),--($F$2:$F$8000<"FL"),--($F$2:$F$8000<"NJ"),$D$2:$D$8000)

If you are totaling numbers in D2:D80000 then you don't need the unary
minuses for the last part


--


Regards,


Peo Sjoblom


"tmwilkin" wrote in message
...
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!