Hi Ian

one way
=IF(A8="","",SUMPRODUCT((F8:AH8="L")+(F8:AH8="H")) )

check out the sumproduct function at
http://www.xldynamic.com/source/xld.SUMPRODUCT.html


Cheers
JulieD

"Ian Harris" wrote in message
. ..
Hi
How can I set this function to look for and count the letter L as well as
H

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

Regards
Ian