Uploaded January 2014 | Updated September 2026, 2 hours ago

---

Get Excel file 00075 here: http://1drv.ms/1bYwrTa

In this video, I explain this array formula:
{=SUM(IFERROR(FIND({1,2,3,4,5,6},MATCH(B2:G2,B2:G2,0)),0))}
It looks complex but I explain each step carefully.
I start from the inside of the formula using the F9 key to evaluate each step.

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