Is there any way to make COUNTIF look for an occurance of a letter in a
cell rather than taking the entire cell as the condition? I am trying
to count the number of cells containing "H" in a range of cells
containing e.g. LTH, BSH, TBH. I would like to count these cells and
return "3". So far I can only get "0" because none of he cells has H
alone.
Peter K
