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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement with multiple criteria and multiple results 3
Formatting Percentages/LOOKUP using a Percentage 2
Formula to compute letter grade based on percentage grade 1
Average of % in pivot table 1
average acts different in rows and columns? 6
Measuring Average Changes 5
Calculating Averages - Very Complex PLEASE HELP 7
How do I add multiple values in an array based on multiple hits? 12

Back
Top