Excel 2007 : Averageif

Hi

I am trying to use the AVERAGEIF formula for the first time and am having problems. I have a list of data I want to get the average of while omitting values that fall below a number in a seperate cell. I can get the command to do this if I physically put the value into the formula but cannot reference the cell containing the value in the formula itself. Can this be done and if so how?

Thanks in advance

PaulMc

This one works also ( entered as an array formula)
=AVERAGE(IF(H4:H9>H2,H4:H9,FALSE))

Thanks for the info. Just what I needed

This has helped with the 2007 version but is there a formula that is 2003 compatible as well? Seems that the workbook will be used by the older excel version as well

The formula I added works on older versions without a problem

Many thanks