Hi All,
I wanted to calculate averages in column D between a range of values given in column B and C from the values in A.
e.g. in the following, I wanted to average of 6,7,9 (D2,D3,D4) based on B1 (i.e.10) and C1 (i.e. 30) which are given in A2 to A4.
A B C D
<tbody>
</tbody>
Thank you so much.
I wanted to calculate averages in column D between a range of values given in column B and C from the values in A.
e.g. in the following, I wanted to average of 6,7,9 (D2,D3,D4) based on B1 (i.e.10) and C1 (i.e. 30) which are given in A2 to A4.
A B C D
1 | 10 | 30 | 3 |
10 | 50 | 60 | 6 |
20 | 90 | 100 | 7 |
30 | 9 | ||
40 | 8 | ||
50 | 4 | ||
60 | 6 | ||
70 | 2 | ||
80 | 5 | ||
90 | 6 | ||
100 | 3 |
<tbody>
</tbody>
Thank you so much.