Thank you. The following formula works:

{=AVERAGE(IF((Schedule!$Q7:$Q46=COLUMNS($E:E))*(Sc hedule!$Z7:$Z460),
Schedule!$Z7:$Z46))}

But I'm getting the #DIV/0! error on the Months which I do not have any
data. How can I default the average to a "0" or <blank if no data is
available for that month, instead of the #DIV/0! error? Please provide
two solutions for "0" or <blank results. Thx.


--
tangomj
------------------------------------------------------------------------
tangomj's Profile: http://www.excelforum.com/member.php...o&userid=36314
View this thread: http://www.excelforum.com/showthread...hreadid=560957