Q:

excel if function does not work

I have some problems with the if function in excel.
I have a set of data I would like to build the average only with some special values. The data is in two columns and the average should be build from column2 if 95if function. If I try a example with simple data, I get this result:

As you can see there are values >5 but I get the result 0.
Can anybody help me?

A:

You should use the AVERAGE function or the AVERAGEIF function for this 

