★0 XP
Question 1 of 10
The COUNTIF function counts the number of text, date, or numerical cells that meet a certain condition. Type =COUNTIF(B2:B8, "MN") to get the number of branches in Minnesota (3)!
| A | B | C | D | |
|---|---|---|---|---|
| 1 | City | State | Sales | |
| 2 | Minneapolis | MN | 400 | |
| 3 | Madison | WI | 1000 | |
| 4 | St. Paul | MN | 500 | |
| 5 | Detroit | MI | 350 | |
| 6 | Des Moines | IA | 280 | |
| 7 | Duluth | MN | 640 | |
| 8 | Lincoln | NE | 650 |
D1fx