Hi,
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
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