average one column based on criteria from another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

scenario:

Column I contains (probability) percentages of 85%, 90%, and 100%
Column N contains (marginal) percentages from 1% to 100%

In a separate cells (in a summary of the report), I need to average the
marginal percentages for each probability percentages.

Any ideas?

Thanks for your help!
 
Maybe =SUMIF(i1:150,85%,n1:n50)/countif(i1:i50,85%)

Or a pivot table
best wishes
 
Back
Top