Download Excel File: https://excelisfun.net/files/EMT1850....
Learn about how to count how many names in a column start with the letters a, b or c. Then make formula dynamic so it can check any set of letters.
Topics:
1. (00:00) Introduction
2. (00:05) Formula that uses LEFT, an array constant {“a”,”b”,”c”} and the SUM function
3. (00:38) Why the two arrays must be in opposite directions
4. (02:22) Dynamic formula linked to a list in the cells.
5. (02:43) Sumamry, Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #count #left #excelfunctions #countifs