average one column based on criteria from another
 

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!

average one column based on criteria from another
 

Maybe =SUMIF(i1:150,85%,n1:n50)/countif(i1:i50,85%)

Or a pivot table
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"ba374" wrote in message
...
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!