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?