Day 29 · Tuesday, 1 September 2026

From the archive

Intermediate

Turn three weighted criteria into one vendor score

SUMPRODUCT multiplies matching entries from two ranges and adds the results — a weighted score in one step instead of three multiplications and a sum.

Task:

You handle vendor selection for a manufacturing company's procurement team. Four vendors have been scored out of 10 on quality, price and delivery, and the weight each criterion carries toward the final decision sits in row 2 — 40% quality, 35% price, 25% delivery. Work out each vendor's overall weighted score in column E, in one formula that pairs each vendor's three scores with the matching weights.

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.