View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default Averaging Indirect Cells

I assume that your months are entered as text, in the manner appearing
in your message. Then, the following *array* formula (needs to be
committed with Shift+Ctrl+Enter) should do:

=AVERAGE(IF(AND(DATEVALUE("1 "&A1:A100)=DATE(1990,1,1),DATEVALUE("1
"&A1:A100)<=DATE(1990,3,1)),B1:B100))

HTH
Kostis Vezerides