I was hoping someone can help me with this. I have been struggling for days and cannot come up with a solution. I have searched through previous answered questions and have only confirmed that I think my formula looks correct but it still wont work out.

AVERAGE(IF(($BA17:$BA321<=-3,9)*($BA17:$BA321>=-5,6),BO17:BO321))

CSE

Can anyone out there see what is wrong with the formula. I think it is pretty eay to see what I want. The average of all numbers in Column BO whose corresponding row in BA is between -3,9 and 5,6

Can anyone help?

Thanks

John