| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating Averages based on criteria
I'm trying to calculate an average based on some criteria in the adjacent
columns. The user has to first identiy Y or N and then determine if the average should be calculated based on 2, 3 or 4 years. Is there a formula that would only averge the correct number of cells 2, 3 or 4 years depending on what the user picked and divide by the right #? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating a Percent based on Tiered criteria | Excel Discussion (Misc queries) | |||
| Calculating the mode of a criteria-based range | Excel Discussion (Misc queries) | |||
| Calculating Mode for multiple arrays based on criteria in another | Excel Worksheet Functions | |||
| Calculating an average based on 2 and 3 criteria | Excel Worksheet Functions | |||
| calculating averages | Excel Worksheet Functions | |||
Threaded Mode
