| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average Array help with a formula
Thank you for your help and the formula worked a treat.
Domenic wrote: Let's assume that Column L may contain 'Attended', try... =AVERAGE(IF($K$15:$K$75="Alc & M Health",IF($L$15:$L$75="Attended",$N$15:$N$75)) ) ...confirmed with CONTROL+SHIFT+ENTER. Hope this helps! Can any one help in this array formula. I need to find the average days in column N selecting Alc & M Health in column K. This formula is working [quoted text clipped - 7 lines] Chris Bennett -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200601/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formula to Pick Average | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Formula for determing average based on weighting | Excel Worksheet Functions | |||
| Average Array Formula | Excel Worksheet Functions | |||
| average, array and offsets | Excel Worksheet Functions | |||
Threaded Mode
