Day 89 · Saturday, 31 October 2026
FILTER takes one include argument, so a rule with two conditions has to be folded into it. Multiplying the two TRUE/FALSE arrays does that row by row, where AND would collapse the whole range into a single answer.
You run accounts receivable for a commercial cleaning company. The finance manager wants this afternoon's collections calls limited to invoices that are worth chasing by phone: $1,000 or more, and more than 30 days overdue. Both have to hold. In F2, use one FILTER formula to list the invoice number, customer and amount (A:C) of every invoice in rows 2 to 9 that meets both conditions.
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.