Conditional Averages

[Montoro22]

So I need to get the averages based on a few determinants. As you see in the example I am trying to find the average response rate or "R.R." (The red section). I want it to match cell A17 to all the cells that match in the larger portion (big table above - column C), and average all of the R.R.'s for those that are "Yes".

Basically I am going to be doing a bunch of these smaller tables that need to pull the determinant that can be located in the main data, and average all of the R.R.'s that match that value (Yes) for this specific case).

Any suggestions??? Thanks!

Rob

[Montoro22]

Sorry one more quick thing, I want the equation to omit and responses that are 0 so it doesn't throw off the average.

[FDibbins]

if you just want to average all "yes's" or all "no's", then use this...
=IFERROR(AVERAGEIF($C$2:$C$10,$A16,$E$2:$E$10),0)

[FDibbins]

Based on your last post, try this...
=IFERROR(AVERAGEIFS($E$2:$E$10,$C$2:$C$10,$A16,$E$2:$E$10,">0"),0)

If you want to break down by company...
=IFERROR(AVERAGEIFS($E$2:$E$10,$C$2:$C$10,$A16,$B$2:$B$10,$B16,$E$2:$E$10,">0"),0)

[Montoro22]

Thanks, worked!

[FDibbins]

happy to help