Exercises / Conditional counting and sums · 5 of 11
Count deals that meet two conditions
COUNTIFS(range1, criteria1, range2, criteria2, …) counts the rows where every condition holds. Each range must be the same size.
Your taskIn G3, use COUNTIFS to count the deals in the region in G1 whose value in C2:C12 is at least G2.
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 | Minimum | $10,000.00 | ||
| 3 | D-02 | West | $8,500.00 | Deals | |||
| 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 |