=AVERAGE(IF(MONTH(A1:A1000)=7,IF(ISNUMBER(B1:B1000 ),B1:B1000,""),""))
Then Press Ctrl+Shift+Enter as this is an array formula

Here is the breakdown on this formula:
Average IF the Month of Column A = 7 (July) and If the same row in
column B is a number.

HTH

Charles Chickering

FPJ wrote:
I know this is very simple problem to most, if not all, of you here but I am
trying to figure out how to create the formula to get the average of column B
of reports created in a certain month (ex. July). Please note that some cells
in column B have the #VALUE! and the dates in column A are in the x/x/xxxx
format. Please help. Thanks.