| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to average division of two columns based on criteria | Excel Discussion (Misc queries) | |||
| Calculate average based on date and other criteria | Excel Discussion (Misc queries) | |||
| calculate average in a column based on criteria in another column | Excel Discussion (Misc queries) | |||
| Calculating an average based on 2 and 3 criteria | Excel Worksheet Functions | |||
| caluculate an average based on 2 criteria | Excel Discussion (Misc queries) | |||
Hybrid Mode
