If Statement help needed please

[Ian Harris]

Hi
How can I get the following function to check and count for the letter L as
well H

=IF(A8="","",COUNTIF(F8:AJ8,"H"))

Regards
Ian

 

[Arvi Laanemets]

Hi

=IF(A8="","",COUNTIF(F8:AJ8,"H")+COUNTIF(F8:AJ8,"L"))

 

[Ian Harris]

Hi Arvi
Many thanks for help
Regards
Ian

Hi

=IF(A8="","",COUNTIF(F8:AJ8,"H")+COUNTIF(F8:AJ8,"L"))

 

[Don Guillett]

try
=if(a8="","",SUMPRODUCT((F8:aj8={"a","h"})*1))