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)


--
Regards
Frank Kabel
Frankfurt, Germany

"Tysone" schrieb im Newsbeitrag
om...
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