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

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

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


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=276839

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