DIV/0 error

[Kidmon]

I am using excel 2007.

I need to average numbers in a column within a date range. The column contains numbers and blank cells. The formula works but it return a DIV/0 error. I know i have a dividing by o problem but I am unsure where and how to edit my formula.
This is my formula:
=AVERAGEIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">=1/1/2012",'2N Stats'!$D:$D,"<=1/11/2012")

What can I do?

Thanx for your help.

 

[mikerickson]

It appears that nothing meets the criteria.
Are you sure that the inequalities are the right way 'round?

 

[Kidmon]

I am not sure what you mean by inequalities or criteria? Do you mean criteria for the error message?

 

[vlady]

to get rid of div/0 specially there is no match in criteria.

=IFERROR(AVERAGEIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">=1/1/2012",'2N Stats'!$D:$D,"<=1/11/2012"),"")