View Single Post
  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

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