Exercises / Conditional counting and sums · 7 of 11
Average delivery time for one carrier and service
AVERAGEIFS(average_range, range1, criteria1, range2, criteria2, …) averages the rows that meet every condition. Like SUMIFS, the range to average comes first.
Your taskIn H3, use AVERAGEIFS to average the delivery days in D2:D13 for the carrier in H1 and the service in H2.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|---|
| 1 | Shipment | Carrier | Service | Days | Carrier | FastShip | ||
| 2 | SH-01 | FastShip | Standard | 4 | Service | Standard | ||
| 3 | SH-02 | Nordline | Express | 1 | Average days | |||
| 4 | SH-03 | FastShip | Express | 2 | ||||
| 5 | SH-04 | FastShip | Standard | 6 | ||||
| 6 | SH-05 | Nordline | Standard | 5 | ||||
| 7 | SH-06 | FastShip | Standard | 3 | ||||
| 8 | SH-07 | Nordline | Express | 2 | ||||
| 9 | SH-08 | FastShip | Express | 1 | ||||
| 10 | SH-09 | Nordline | Standard | 7 | ||||
| 11 | SH-10 | FastShip | Standard | 5 | ||||
| 12 | SH-11 | Nordline | Express | 3 | ||||
| 13 | SH-12 | FastShip | Express | 2 |