Weighted Average with OR function

[suiz919]

Hi-

I'm trying to find the weighted average of column D & E if Column I is "A","B", or "C" and Column A is equal to "FI"

this is what i have so far, but it's giving me an error

<style>table { }td { padding: 0px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }ruby { }rt { color: windowtext; font-size: 8pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Verdana; display: none; }</style> <table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="86"> <col style="" width="86"> <tbody><tr height="14"> <td height="14" width="86">SUMPRODUCT(--(A2:A12="FI"),--(ISNUMBER(MATCH(I2:I12,{"a";"b";"c"},0))),($D$2:$D$12,$E$2:$E12)/
SUMPRODUCT(--(A2:A12="FI"),--(ISNUMBER(MATCH(I2:I12,{"a";"b";"c"},0))),($D$2:$D$12)

</td> </tr> </tbody></table> Please help. Much appreciated.

 

[Marcelo Branco]

Try to delete the parentheses in red

=SUMPRODUCT(--(A2:A12="FI"),--(ISNUMBER(MATCH(I2:I12,{"a";"b";"c"},0))),($D$2:$D$12,$E$2:$E12)/SUMPRODUCT(--(A2:A12="FI"),--(ISNUMBER(MATCH(I2:I12,{"a";"b";"c"},0))),($D$2:$D$12)


M.

 

[T. Valko]

Hi-

I'm trying to find the weighted average of column D & E if Column I is "A","B", or "C" and Column A is equal to "FI"

this is what i have so far, but it's giving me an error

<STYLE>table { }td { padding: 0px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }ruby { }rt { color: windowtext; font-size: 8pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Verdana; display: none; }</STYLE><TABLE style="BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=86 border=0><COLGROUP><COL width=86><TBODY><TR height=14><TD width=86 height=14>SUMPRODUCT(--(A2:A12="FI"),--(ISNUMBER(MATCH(I2:I12,{"a";"b";"c"},0))),($D$2:$D$12,$E$2:$E12)/
SUMPRODUCT(--(A2:A12="FI"),--(ISNUMBER(MATCH(I2:I12,{"a";"b";"c"},0))),($D$2:$D$12)


</TD></TR></TBODY></TABLE>Please help. Much appreciated.

Think you just had some misplaced parentheses.

This...

=SUMPRODUCT(--(A2:A12="FI"),--(ISNUMBER(MATCH(I2:I12,{"a";"b";"c"},0))),$D$2:$D$12,$E$2:$E12)/SUMPRODUCT(--(A2:A12="FI"),--(ISNUMBER(MATCH(I2:I12,{"a";"b";"c"},0))),$D$2:$D$12)

 

[Marcelo Branco]

Think you just had some misplaced parentheses.

This...

=SUMPRODUCT(--(A2:A12="FI"),--(ISNUMBER(MATCH(I2:I12,{"a";"b";"c"},0))),$D$2:$D$12,$E$2:$E12)/SUMPRODUCT(--(A2:A12="FI"),--(ISNUMBER(MATCH(I2:I12,{"a";"b";"c"},0))),$D$2:$D$12)

Biff,

Exactly at the same time!!!

Are you following me?

M.

 

[T. Valko]

Biff,

Exactly at the same time!!!

Are you following me?

M.

Not any more!

I'm calling it a day.

It's all yours!

 

[suiz919]

Thank you sooo much. It worked! You guys are genuises.

 

[Marcelo Branco]

Thank you sooo much. It worked! You guys are genuises.

You are welcome.

Glad to help

M.

 

[T. Valko]

Thank you sooo much. It worked! You guys are genuises.

You're welcome. Thanks for the feedback!