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

T

Aladin Akyurek wrote in message ...
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)


Tysone Wrote:
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