If Statement help needed please
 

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

Hi

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


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)



"Ian Harris" wrote in message
. ..
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

Hi Arvi
Many thanks for help
Regards
Ian
"Arvi Laanemets" wrote in message
...
Hi

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


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)



"Ian Harris" wrote in message
. ..
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

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

--
Don Guillett
SalesAid Software

"Ian Harris" wrote in message
. ..
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