← Lookups and Logic Lesson 3 of 5
SUMIFS and COUNTIFS: totals with conditions What you will be able to do
Total and count rows meeting one or several criteria, and get the argument order right first time.
"How much did Brookside do in Tools last quarter?" is the most common question anyone will ever ask you about a spreadsheet. Two functions answer almost every version of it.
Step 1 of 6 · 1 point
Total the line totals for the Brookside branch.
Start Here Sales Prices Commission Commission Run
A B C D E F G H I J 1 OrderID Date Branch Rep Category Product Qty UnitPrice Discount LineTotal 2 4001 2026-01-05 Fairview Priya Raghavan Electrical Romex 12-2 250ft 4 148.00 0.1 532.80 3 4002 2026-01-05 Fairview Priya Raghavan Electrical Romex 12-2 250ft 5 148.00 0 740.00 4 4003 2026-01-06 Northgate Marcus Ellery Paint Wood primer, 1gal 2 46.75 0.05 88.83 5 4004 2026-01-07 Northgate Marcus Ellery Plumbing Ball valve 1/2in 1 9.25 0.05 8.79 6 4005 2026-01-07 Brookside Danielle Okafor Plumbing Copper pipe 1/2in 10ft 1 31.40 0 31.40 7 4006 2026-01-08 Brookside Danielle Okafor Plumbing Copper pipe 1/2in 10ft 1 31.40 0 31.40 8 4007 2026-01-08 Brookside Danielle Okafor Paint Interior latex paint, 5gal 3 138.00 0.05 393.30 9 4008 2026-01-08 Brookside Danielle Okafor Tools Cordless drill 18V 5 209.00 0.1 940.50 10 4009 2026-01-09 Fairview Priya Raghavan Plumbing Ball valve 1/2in 3 9.25 0 27.75 11 4010 2026-01-09 Northgate Marcus Ellery Paint Roller and tray set 6 14.20 0 85.20 12 4011 2026-01-09 Brookside Danielle Okafor Plumbing Water heater element 4500W 6 24.10 0 144.60 13 4012 2026-01-10 Northgate Marcus Ellery Tools Cordless drill 18V 1 209.00 0 209.00 14 4013 2026-01-10 Northgate Marcus Ellery Plumbing Copper pipe 1/2in 10ft 4 31.40 0.05 119.32
Rows 1 to 14 of 315 Up Down
⚠ Report a problem