0
Undo
Votes
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!
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.