I have the following formula
=AVERAGE(IF(D422:D427L422,H422:H427,"FALSE")*H422 :H427)

That averages whats in H422:H427 if D422:D427 is greater than L422(which is a date). The problem i have if that some of the cells in column H have negative values and i cannot seem to ignore them.