View Single Post
  #4   Report Post  
Don Guillett
 
Posts: n/a
Default

try
=if(a8="","",SUMPRODUCT((F8:aj8={"a","h"})*1))

--
Don Guillett
SalesAid Software

"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