Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional w/ arrays
I am trying to get the average of several numbers using arrays. I want
average only if the date with the values are associated with a date range. {=AVERAGE(IF(AND($E$2:$E$6<I6,$E$2:$E$6<I5),$D$2:$ D$6,""))} |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use of arrays | Excel Worksheet Functions | |||
Use of arrays | Excel Worksheet Functions | |||
Fantasy Football Conditional Arrays | Excel Worksheet Functions | |||
Need help with arrays (I think) | Excel Worksheet Functions | |||
Arrays | Excel Worksheet Functions |