Weighted Average IF (sumproduct conditional)

Try this, copied down...
=SUMPRODUCT(($E$2:$E$25=A2)*($F$2:$F$25)*($G$2:$G$25))

Leopold2000, Good afternoon.

May I try to give some contribuition?

I think Weighted Average is interpreted by the formula as follow:

=SUMPRODUCT(($E$2:$E$25=A2)*($F$2:$F$25)*($G$2:$G$25))/SUMIF($E$2:$E$25,A2,$G$2:$G$25)

Please, let me know if itīs different.
I hope it helps.

Attention! What you want to do when the ratings of a range is 0,00 ?


Regards from Brazil

Create a helper column H and enter this formula in H2 and copy down the length of your data:

Formula:

Please Login or Register  to view this content.

In B2 enter this and copy down the length of your data:

Formula:

Please Login or Register  to view this content.

In column G you have several 0 values. I understand this to mean to take the value in column F as is otherwise multiply column F values by the values in column G.