If Statement help needed please

Ian Harris · Dec 3, 2004

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 · Dec 3, 2004

Hi

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

Ian Harris · Dec 3, 2004

Hi Arvi
Many thanks for help
Regards
Ian

Arvi Laanemets said:
Hi

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

Don Guillett · Dec 3, 2004

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