Level 2 · Find the slow movers in Excel

What the sheet holds

Priya’s export has one row per active Outdoor product:

column	holds
A	product
B	launch year
C	unit cost, blank when nobody entered it
D, E	units and net revenue in 2025, completed orders

Rows 2 to 17 are the 16 products launched before 2025, on sale for the whole year. Rows 18 and 19 are the two launched during 2025; they stay on the sheet so the check can count them, but they get no share and are left out of the ranking.

Step 1: check before you rank

An export is someone else’s query, so start by counting what is in it:

H2  =COUNTIF(B2:B19,2025)
H3  =COUNTBLANK(C2:C19)
H4  =COUNTIF(D2:D19,0)

Each count answers a question the recommendation will need. How many products are too new to judge? How many have no cost, so their margin is unknown? Did anything not sell at all? Here the answers are two, three and none.

Step 2: shares, then a line

A product’s share of the category is its revenue over the total of the established products. SUMIF builds that total by adding column E only where the launch year is before 2025, and IF leaves the two new launches empty:

=IF(B2=2025,"",E2/SUMIF($B$2:$B$19,"<2025",$E$2:$E$19))

The $ signs lock the ranges, so the same formula fills down to F19. Format the column as a percentage. Then two summary cells, which skip the empty text in rows 18 and 19:

H7  =MIN(F2:F19)
H8  =COUNTIF(F2:F19,"<0.02")

A share works where a raw ranking does not: the Tidewater string lights and a $52 Adirondack chair are in the same category but not at the same price, and the share puts them on one scale of “how much of Outdoor does this product carry”.

Reading the result

Six of the 16 established products each bring in under 2% of Outdoor revenue. Two of those six, the Cedar Concrete Grill Tool Set and the Driftwood Acacia Planter, are also among the three with no unit cost, so nobody can say yet whether they make money.

Outdoor sells mostly from April to July, which is why this export uses the whole year. The Fern Concrete Raised Garden Bed sold 11 units in 2025, only 2 of them from July to December: judged on the second half of the year alone it would look dead.

Pitfalls

• A blank cell is not zero: count missing values with COUNTBLANK.
• Leaving new launches in the total lowers every share and puts a product launched in August on the list.
• A condition in COUNTIF goes in quotes, operator included: "<0.02".