F2
=
Type your formula...
Sheets Daily
0:00
easy
Count how many Q1 rows there are.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Company | Region | Quarter | Revenue |
| 2 | Acme Co | West | Q1 | 18,400 |
| 3 | Acme Co | West | Q2 | 22,100 |
| 4 | Acme Co | West | Q3 | 31,700 |
| 5 | Acme Co | West | Q4 | 48,200 |
| 6 | Globex | East | Q1 | 14,200 |
| 7 | Globex | East | Q2 | 19,800 |
| 8 | Globex | East | Q3 | 23,400 |
| 9 | Globex | East | Q4 | 28,100 |
| 10 | Initech | Central | Q1 | 9,200 |
| 11 | Initech | Central | Q2 | 12,400 |
| 12 | Initech | Central | Q3 | 15,800 |
| 13 | Initech | Central | Q4 | 19,200 |
| 14 | Umbrella | West | Q1 | 28,100 |
| 15 | Umbrella | West | Q2 | 31,200 |
| 16 | Umbrella | West | Q3 | 34,800 |
| 17 | Umbrella | West | Q4 | 42,400 |
F2