I am currently pulling a query into Microsoft Excel and I need to create a
function that averages all cells from a specific month. So i need to have
one cell that searchs all the queried data and pulls every number for a
specific plant and month in june and then averages all the numbers it finds.

For example below... I could just say =averge(B1:B5) except the range will
increase every month, and then every year. So I am looking for a function
that says look for TMMKV6 Engine Assy for every month 11 regardless of the
year. Each month the query will run the averages for the new month should
change and the old one's will only change once every year.

A B
TMMKV6 Engine Assy112005 0.86621058
TMMKV6 Engine Assy112004 0.850701809
TMMKV6 Engine Assy112003 0.805216908
TMMKV6 Engine Assy112002 0.805999994

Thank you for your help.