Exercises / Conditional counting and sums · 6 of 11
Average deal size in one region
AVERAGEIF(range, criteria, average_range) averages only the rows that meet the condition. It has the same shape as SUMIF.
Your taskIn G2, use AVERAGEIF to average the deal values in C2:C12 for the region in G1.
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 |
|---|---|---|---|---|---|---|---|
| 1 | Deal | Region | Value | Region | East | ||
| 2 | D-01 | East | $12,000.00 | Average | |||
| 3 | D-02 | West | $8,500.00 | ||||
| 4 | D-03 | East | $10,000.00 | ||||
| 5 | D-04 | East | $4,300.00 | ||||
| 6 | D-05 | West | $22,000.00 | ||||
| 7 | D-06 | East | $31,000.00 | ||||
| 8 | D-07 | West | $15,500.00 | ||||
| 9 | D-08 | East | $9,900.00 | ||||
| 10 | D-09 | West | $20,000.00 | ||||
| 11 | D-10 | East | $18,750.00 | ||||
| 12 | D-11 | West | $6,100.00 |