Day 36 · Tuesday, 8 September 2026

From the archive

Intermediate

Average order value for one channel and one region — then a threshold on top

AVERAGEIFS averages a range, but only over the rows where every condition you give it holds — the same range/criteria pairs SUMIFS and COUNTIFS use, with a mean at the end instead of a total.

Task:

You handle sales reporting for a home goods retailer that sells through an online store and physical branches. Eight orders came in yesterday, each logged with its channel, region and amount. In D10, work out the average order value for Online orders placed in the East region. In D11, work out the average order value for In-Store orders under $70.

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.