In my array I have several conditions. I would like one of those conditions
to look at a date (in another column; 01-sep-2006) and select those in a
specific year (i.e.
2006.

{=AVERAGE(IF(($A$5:$A$113=Q7)*($K$5:$K$1130)*($M$ 5:$M$1130)*($O$5:$O$113=0)*($O$5:$O$113= ),$O$5:$O$113))}