Hello,
having an issue with a counting code. below is the code:
=IF(ISNUMBER(SEARCH("ASGN",A20:A24)),"1","0")
the problem I am having is that If I only look at one it works, if I try more than one then it does not add those cells together.
am I missing something
Erick
having an issue with a counting code. below is the code:
=IF(ISNUMBER(SEARCH("ASGN",A20:A24)),"1","0")
the problem I am having is that If I only look at one it works, if I try more than one then it does not add those cells together.
am I missing something
Erick