AVERAGEIF function using reference as criteria range

I am trying to use the AVERAGEIF function to give calculate averages based on dynamic data. The formula I want to work is:

=AVERAGEIF(J9:J27,">D6",L9:L27)

but this returns the "#DIV/0!" error.

However,

=AVERAGEIF(J9:J27,">10000",L9:L27)

returns the correct value.

I want to be able to calculate averages of only the cells that are greater than the value of cell D6. Is there a way to do this?

Thanks in advance.

-Andy