Note: The other languages of the website are Google-translated. Back to English
English English
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  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.