SUMPRODUCT or SUMIFS that will allow formulas

[PaulFogel123]

I have a simple database, attached. I want to calculate the average weight by class. Column G does this with a SUMIF formula. I also experimented with SUMPRODUCT for this purpose. However, I want to eliminate column D, and these functions want a matching range like column D, not a formula. What formula can I use to do this?
Paul

 

[Villalobos]

Hi,

Something like this?

=SUMPRODUCT(($A$3:$A$24=$F5)+0,$B$3:$B$24,$C$3:$C$24/100)/(SUMIF($A$3:$A$24,$F5,$C$3:$C$24)/100)

 

[Luke M]

Or like this:
=SUMPRODUCT(($A$3:$A$24=F3)*($B$3:$B$24)*($C$3:$C$24))/SUMIF($A$3:$A$24,F3,$C$3:$C$24)

 

[PaulFogel123]

Hi,

Something like this?

=SUMPRODUCT(($A$3:$A$24=$F5)+0,$B$3:$B$24,$C$3:$C$24/100)/(SUMIF($A$3:$A$24,$F5,$C$3:$C$24)/100)

That works! Thanks!

 

[PaulFogel123]

Or like this:
=SUMPRODUCT(($A$3:$A$24=F3)*($B$3:$B$24)*($C$3:$C$24))/SUMIF($A$3:$A$24,F3,$C$3:$C$24)

Brilliant.