| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column Average Given 2 Criteria
I want to get the average for a certain column, given 2 different criteria.
Right now I'm using this formula for one criteria: =SUMIF($Q$3:$Q$114,"=10",$E$3:$E$114)/COUNTIF($Q$3:$Q$114,"=10") I want to also include that R3:R114 equals 1. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare cells in column to criteria, then average next column cell | Excel Worksheet Functions | |||
| average one column based on criteria from another | Excel Discussion (Misc queries) | |||
| how can I average more cells only in a column by a criteria? | Excel Worksheet Functions | |||
| calculate average in a column based on criteria in another column | Excel Discussion (Misc queries) | |||
| Average given criteria, HELP! | Excel Worksheet Functions | |||
Threaded Mode
