aviationgeek
New Member
- Joined
- Oct 20, 2015
- Messages
- 4
Good Afternoon -
I am having a problem with averageifs and or combination. It is not working like I have expected it to, and I have not been able to find a solution to my problem on-line.
I am looking at the following table:
<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>
I want to find the average time time for a Bank Number 1, on 10/10/2015, and used either runway 9 or 8R. The issue I am having is that with the runway portion. I so far have =AVERAGEIFS(E2:E8,A2:A8,"=1",C2:C8,DATE(2015,10,10)), but I have not been able to figure out how to have both runway conditions in the formula.
Any help would be great.
Thank you
I am having a problem with averageifs and or combination. It is not working like I have expected it to, and I have not been able to find a solution to my problem on-line.
I am looking at the following table:
Bank | Runway | Date | Taxi Time | |
1 | 8R | 10/10/2015 | 5 | |
1 | 9 | 10/10/2015 | 8 | |
1 | 9 | 10/10/2015 | 4 | |
1 | 26L | 10/10/2015 | 7 | |
1 | 9 | 10/11/2015 | 4 | |
2 | 9 | 10/10/2015 | 9 | |
2 | 26L | 10/11/2015 | 2 |
<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>
I want to find the average time time for a Bank Number 1, on 10/10/2015, and used either runway 9 or 8R. The issue I am having is that with the runway portion. I so far have =AVERAGEIFS(E2:E8,A2:A8,"=1",C2:C8,DATE(2015,10,10)), but I have not been able to figure out how to have both runway conditions in the formula.
Any help would be great.
Thank you