Day 80 · Thursday, 22 October 2026
SUMPRODUCT doesn't stop at two ranges — hand it a third and it multiplies all three together, row by row, before it ever adds anything up.
You handle the import paperwork for a small retailer bringing in a shipment with four different product lines. Each line has its own quantity, unit value in dollars, and duty rate — tariffs vary by what's actually being imported, so no two lines pay the same percentage. In B6, find the shipment's total declared value: every line's quantity times its unit value, all added together. In B7, find the total duty owed: every line's quantity times its unit value times its own duty rate, all added together.
A new exercise every morning, plus every day that came before it — a back catalogue that grows by one a day, whether or not you were here for it.
The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.