Conflicting answers with formula

[ukphoenix]

]I have a new problem with the formula here. It works asfar as counting the numbers but the issue i have is that the sheet uses other letters in other columns and is conflicting.
How do I get it to only pick up the "L" and not the others

Original formula

=SUMPRODUCT(--SUBSTITUTE("S"&UPPER(B4:AF4),"S",0))

Original question and replies http://www.excelforum.com/excel-gene...-required.html