A new Excel trick every day on our Facebook page.Follow us →
LX
← 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.

0 XP

Step 1 of 6 · 1 point

Total the line totals for the Brookside branch.

ABCDEFGHIJ
1OrderIDDateBranchRepCategoryProductQtyUnitPriceDiscountLineTotal
240012026-01-05FairviewPriya RaghavanElectricalRomex 12-2 250ft4148.000.1532.80
340022026-01-05FairviewPriya RaghavanElectricalRomex 12-2 250ft5148.000740.00
440032026-01-06NorthgateMarcus ElleryPaintWood primer, 1gal246.750.0588.83
540042026-01-07NorthgateMarcus ElleryPlumbingBall valve 1/2in19.250.058.79
640052026-01-07BrooksideDanielle OkaforPlumbingCopper pipe 1/2in 10ft131.40031.40
740062026-01-08BrooksideDanielle OkaforPlumbingCopper pipe 1/2in 10ft131.40031.40
840072026-01-08BrooksideDanielle OkaforPaintInterior latex paint, 5gal3138.000.05393.30
940082026-01-08BrooksideDanielle OkaforToolsCordless drill 18V5209.000.1940.50
1040092026-01-09FairviewPriya RaghavanPlumbingBall valve 1/2in39.25027.75
1140102026-01-09NorthgateMarcus ElleryPaintRoller and tray set614.20085.20
1240112026-01-09BrooksideDanielle OkaforPlumbingWater heater element 4500W624.100144.60
1340122026-01-10NorthgateMarcus ElleryToolsCordless drill 18V1209.000209.00
1440132026-01-10NorthgateMarcus ElleryPlumbingCopper pipe 1/2in 10ft431.400.05119.32
Click and drag across cells to see their Average, Count and Sum here.
Rows 1 to 14 of 315
Name BoxQ2fx