If statement help needed

[Ian Harris]

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

 

[JulieD]

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]

Hi Julie
Many thanks for help
Regards
Ian

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