ExcelBanter - If statement help needed

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If statement help needed (https://www.excelbanter.com/excel-worksheet-functions/7404-if-statement-help-needed.html)

Ian Harris

If statement help needed

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" 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

Ian Harris

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

All times are GMT +1. The time now is 11:59 AM.