filtering numbers?

Originally Posted by NBVC

I only noticed that you added a workbook after seeing your rep points comment. You should reply next time and add attachment, this way it will go back to top of my list and I will know you added some information....

.. anyway, still a little confused. You did not show expected result.

Are you looking for perhaps:

=AVERAGEIF(A5:A113,"<="&B4,B5:B113)

Hi NBVC
Think of the average (20) in column B as a sell order. Any market that reaches that number will trigger a sell signal. A formula that filters out figures higher than the column B average but includes the lower & negative numbers should work. So, a max value of 20 (B average) and all bellow needs to be entered.

Alex G

Originally Posted by Alex G

Hi NBVC
Think of the average (20) in column B as a sell order. Any market that reaches that number will trigger a sell signal. A formula that filters out figures higher than the column B average but includes the lower & negative numbers should work. So, a max value of 20 (B average) and all bellow needs to be entered.

Alex G

Tried the formula NBVC, didn't seem to work. Manually, the result worked out at 16.60.

Alex G