Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, 13 February 2019
  0 Replies
  2.6K 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.