Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Counting into a summary table. COUNTIFS counts rows that match, so it fills the “how many” column of a summary table. Unlike a pivot table, a label typed in the first column stays even when nothing matches: it simply shows 0, which is often exactly what the reader needs to see.
=COUNTIFS($C$2:$C$60,F2) tickets per support queue, queue in F2
The partner programme review asks how many Q4 partner orders came from each customer segment, and what they were worth. Enterprise stays in the table even if it has no orders.
In H2:H4, count the orders in A2:A33 for the segment in G2:G4. In I2:I4, total their values from E2:E33. Fill each column down from row 2. No rounding.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Customer | Segment | Value | Segment | Orders | Value | |
| 2 | 50836 | 2025-10-04 | Granite Labs | SMB | 15.50 | SMB | |||
| 3 | 50842 | 2025-10-07 | Atlas Dental | SMB | 183.60 | Mid-Market | |||
| 4 | 50868 | 2025-10-15 | Granite Labs | SMB | 101.50 | Enterprise | |||
| 5 | 50871 | 2025-10-16 | Granite Bakery | SMB | 182.73 | Total | 0 | 0.00 | |
| 6 | 50874 | 2025-10-16 | North Pharmacy | SMB | 167.00 | ||||
| 7 | 50878 | 2025-10-18 | Beacon Fitness | SMB | 125.00 | ||||
| 8 | 50895 | 2025-10-24 | Harbor Fitness | SMB | 66.97 | ||||
| 9 | 50917 | 2025-11-03 | Blue Accounting | SMB | 296.30 | ||||
| 10 | 50934 | 2025-11-06 | Granite Clinic | SMB | 181.55 | ||||
| 11 | 50945 | 2025-11-11 | North Media | SMB | 108.00 | ||||
| 12 | 50954 | 2025-11-13 | Atlas Bakery | Mid-Market | 377.04 | ||||
| 13 | 50964 | 2025-11-17 | Beacon Architects | Mid-Market | 285.21 | ||||
| 14 | 50969 | 2025-11-18 | Copper Labs | SMB | 125.40 | ||||
| 15 | 50973 | 2025-11-19 | Silver Fitness | SMB | 177.50 | ||||
| 16 | 50982 | 2025-11-21 | Falcon Consulting | SMB | 255.00 | ||||
| 17 | 50984 | 2025-11-22 | River Dental | SMB | 147.13 | ||||
| 18 | 50993 | 2025-11-26 | Copper Dental | SMB | 234.00 | ||||
| 19 | 50995 | 2025-11-26 | Oak Fitness | Mid-Market | 136.50 | ||||
| 20 | 51001 | 2025-11-27 | Maple Academy | Mid-Market | 606.30 | ||||
| 21 | 51010 | 2025-12-02 | Beacon Hotels | SMB | 275.60 | ||||
| 22 | 51032 | 2025-12-10 | North Architects | Mid-Market | 19.80 | ||||
| 23 | 51034 | 2025-12-10 | Harbor Hotels | SMB | 182.00 | ||||
| 24 | 51038 | 2025-12-11 | Orchard Law Group | SMB | 72.80 | ||||
| 25 | 51044 | 2025-12-12 | Silver Pharmacy | SMB | 87.30 | ||||
| 26 | 51048 | 2025-12-15 | Meadow Consulting | SMB | 105.60 | ||||
| 27 | 51050 | 2025-12-16 | Harbor Hotels | SMB | 248.63 | ||||
| 28 | 51058 | 2025-12-18 | Silver Clinic | SMB | 124.85 | ||||
| 29 | 51063 | 2025-12-19 | Harbor Studios | SMB | 531.63 | ||||
| 30 | 51070 | 2025-12-22 | Blue Motors | Mid-Market | 590.60 | ||||
| 31 | 51078 | 2025-12-24 | Beacon Fitness | SMB | 78.43 | ||||
| 32 | 51080 | 2025-12-24 | Meadow Dental | SMB | 323.22 | ||||
| 33 | 51083 | 2025-12-25 | Bright Labs | SMB | 108.30 | ||||
| 34 | |||||||||
| 35 | |||||||||
| 36 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe