Sumproduct Multiple Conditions
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
|