count duplicated string in Range for each letter,Non Adjacent Row

Try this formula in AB3 and drag it down:

Formula:

=SUMPRODUCT(($EW$3:$FA$38=AA3)*($FK$3:$FK$38=RIGHT($AB$2,1)))