Single-cell Formula to Filter Specific Columns and Calculate Running Total in Excel

The modern #Excel functions like LET, FILTER, CHOOSECOLS, SCAN, HSTACK functions combined with veteran COUNTIF function makes it much fun and easier to author a single-cell formula that performs a ton of lifting. This videos shows how to use all the above function in a single-cell array formula operation in Excel.