Wednesday, 13 February 2019
  0 Replies
  1.3K Visits
0
Votes
Undo
Trying to find a formula that will look at a column (Column D) for everything after row 7. If the number is between 3.0-3..99 I want to average the number that is in column L starting in Row 7.

So it maybe

Column D
3.2
3.4
5
7
3.9

Column L
250
325
175
100
300

And 1, 2, 5 would be in the range and the average would be $291.66

is there an easy formula that can do this?

thanks!
There are no replies made for this post yet.