CODEWITHSUNDEEP
excelexcel-formulaarray-formulas
user25565215
user25565215

Reputation: 1

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

I have tried looking at LEN formulas but am stuck!

Upvotes: 0

Views: 76

Answers (1)

Black cat
Black cat

Reputation: 6177

One approach with FIND function

=SUM(IF(IFERROR(FIND(C$4,$A$2:$A$9),0)>0,1,0))

in cell D4. Copy D4 to the other result cells.

enter image description here

Upvotes: 2

Related Questions