Day 80 · Thursday, 22 October 2026

From the archive

Advanced

Total a multi-line customs declaration with a three-array SUMPRODUCT

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.

Task:

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.

The daily challenge is part of Pro

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.

Every day so far

August 2026

September 2026

October 2026

November 2026

18
SolvedOpenProLatest

Recent days

The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.