Sumproduct Multiple Conditions

[Tysone]

I understand how to do one condition, but I can't seem to find out how
to do two.

Here is what I have for my current formula (it's doing a weighted
average if you couldn't figure it out)

=SUMPRODUCT(--($E$2:$E$10001=11), $I$2:$I$10001,
$O$2:$O$10001)/SUMIF($E:$O,11,$O:$O)


What I need it to also do is recognize a second criteria. I need it
to somehow also do this:

$G$2:$G$10001=2

If there is a better way to do this so it will pick up 11 and 2, I'm
open for suggestions.


Thanks

Tyson

 

[Frank Kabel]

Hi
try:
=SUMPRODUCT(--($E$2:$E$10001=11),--($G$2:$G$10001=2
),$I$2:$I$10001,$O$2:$O$10001)/SUMIF($E:$O,11,$O:$O)

 

[Aladin Akyurek]

Just include the conditional term and, although it would work as is, se
up the ranges for SumIf in the same way as for SumProduct...

=SUMPRODUCT(--($E$2:$E$10001=11),--($G$2:$G$10001=2
),$I$2:$I$10001,$O$2:$O$10001)/SUMIF($E$2:$E$10001,11,$O$2:$O$10001)

 

[Tysone]

Thanks for the help... Got it to work.

T

Just include the conditional term and, although it would work as is, set
up the ranges for SumIf in the same way as for SumProduct...

=SUMPRODUCT(--($E$2:$E$10001=11),--($G$2:$G$10001=2
),$I$2:$I$10001,$O$2:$O$10001)/SUMIF($E$2:$E$10001,11,$O$2:$O$10001)