Good day all,
I have not really used the =averageif function and was wondering if i could have some help.
Lets say I have the table below....
Basically what I was to do is find the average/min/max of my value 1 column if my depth 3 column fits between the depth 1 and depth 2 column.
For example using the table below I want to find the average of my value 1 column if it falls within a certain depth range from depth 1 and depth 2
If i want to find those values I need 3 formulas that will give me the average/min/max of all values 1 column that have a depth 3 range that fall within the range between cells A2 and B2
the resulting formulas in cells F2, G2, and H2 would produce..
Average of =50
Max of = 100
Min of = 50
can anyone help me out?
<tbody>
</tbody>
-R
I have not really used the =averageif function and was wondering if i could have some help.
Lets say I have the table below....
Basically what I was to do is find the average/min/max of my value 1 column if my depth 3 column fits between the depth 1 and depth 2 column.
For example using the table below I want to find the average of my value 1 column if it falls within a certain depth range from depth 1 and depth 2
If i want to find those values I need 3 formulas that will give me the average/min/max of all values 1 column that have a depth 3 range that fall within the range between cells A2 and B2
the resulting formulas in cells F2, G2, and H2 would produce..
Average of =50
Max of = 100
Min of = 50
can anyone help me out?
A | B | C | D | E | F | G | H | |
1 | Depth 1 | Depth 2 | -- | Depth 3 | Value 1 | Average | Min | Max |
2 | 1 | 10 | 7 | 50 | ??? | ??? | ??? | |
3 | 11 | 20 | 8 | 50 | ||||
4 | 21 | 30 | 9 | 50 | ||||
5 | 31 | 40 | 10 | 100 | ||||
6 | 41 | 50 | 11 | 100 |
<tbody>
</tbody>
-R