Uploaded July 2015 | Updated September 2026, 2 hours ago

---

Get Excel file 00133 here: http://1drv.ms/1bYwrTa
Given a value of '354', look for each individual digit inside of cells in a column and add up sales values to the left.

I show you 2 solutions: (a) crazy array formula, (b) step by step helper column approach (much easier to explain)

Idea inspired from Tom Urtis tweet (fuzzy match sum). Shorter alternative array by Zoran Stanojević. Thanks!

00:00 Challenge explanation
02:31 Helper column approach
05:26 Crazy array formula approach!
17:43 Recap

Cheers,
Kevin Lehrbass
twitter.com/kevinlehrbass
myspreadsheetlab.com