Hi Julie
Many thanks for help
Regards
Ian
"JulieD" wrote in message
...
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