Counting the Number of Occurrences of Multiple Single Characters in a Range
I have made an attendance tracker in which adding a letter to a cell denotes the type of “attendance” that is being tracked within a range (monthly range, each day is a cell). A for absent, T for late time change request, S for late conversion, L for late call out. I have a COUNTIF formula tabulating the letters placed in the cell that is counted in individual cells, but I realize now I may need to enter multiple letters on a single day/single cell. I am unsure how to write a formula for counting the number of occurrences of a single letter, but potentially multiple letters within the single cell of a range. screenshot of sheet