← The libraryPractice · 1 questions →
Excel concept
Boolean math and SUMPRODUCT
Comparisons return TRUE/FALSE; multiplying or double-negating turns them into 1/0 so they can be summed.
CommonDifficulty 1723 · Expert
The shape of it
- In practice
Use SUMPRODUCT((cond1)*(cond2)*values) when SUMIFS cannot express the condition, like comparing two columns.
Related
Learn the moves here — or let Wauvel run them on your numbers.
$99/mo, everything included. Free for 14 days, no card.
One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.