Some thoughts for this part:
{=AVERAGE(IF(MONTH(Dates)=6,IF(Dates<G2),IF(Dates <H2),Search,""))))}
Technically I can copy this down and just change the month to 7, 8, 9...but
that only works if I have one year. After that I need to add the YEAR
(doable, but still fairly manual).

If you replace this term in the above: MONTH(Dates)=6
with this unambiguous, automated one:
TEXT(Dates,"mmmyyyy")=TEXT(DATE(2008,ROWS($1:1)+5, 1),"mmmyyyy")
you can then copy down your expression as far as required w/o having to
manually change each successive row. It'll roll over the year as well.

P/s: Keep it to one specific query per post
Make it attractive for responders to respond

If the above helped (believe it should), remember to press the YES button
below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---