Thread
:
If Statement help needed please
View Single Post
#
4
Don Guillett
Posts: n/a
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
Reply With Quote