Wrap Text General copy te Format B I U The table below shows performance data fo

Question

Wrap Text General copy te Format B I U The table below shows performance data for 100 flights between cities A-G for some airline, induding: date, flight #, origin, destination, # passengers flown (load), and tardiness (late, in hours). Create automatic rules to return, in the specified cells, the following 1.(89):number of flights from city (17) to city (U7) on date (7) [10 pts) B 09/01/17 2. (B13j: # passengers flown from dty (K11) between date an) and date (Min10 pts A 09/01/17 09/01/17 . (817) average tardiness for all flights from city (015) to city (K15) [10 pts Date 09/01/17 2105 09/01/17 8224 09/01/179493 09/01/17 1665 D 09/01/17 5450 From 230 0.32 175 0.64 233 0.82 287 0.59 212 086 214 0.88 289 0.60 0.18 09/01/17 1479 27 09/01/17 5113 314 09/01/17 7493 09/01/17 1762 09/01/17 9339 09/01/173508 09/01/176311 0/01/175141 09/01/179059 255 0.54 0.92 2900.99 206 0.40 213 0.53 272 0.72 316 0.04 260 0.32 09/01/17 2016 09/01/17 4775 09/01/17 3818 09/01/17 5372 35 205 0.60 264 0.55 Ready 0 2 3

Explanation / Answer

I assume the last data in the excel is at the row 38. You can modify the formula by replacing 38 by the last row no. of the data.

1.

=COUNTIFS(D21:D38,I7,E21:E38,J7,B21:B38,K7)

2.

=SUMIFS(F21:F38,D21:D38,"="&K11,B21:B38,">="&L11,B21:B38,"<="&M11)

3.

=AVERAGEIFS(G21:G38,D21:D38,"="&J15,E21:E38,"="&K15)

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.