by tar@[EMAIL PROTECTED]
(Thomas A. Russ)
Jun 7, 2007 at 04:50 PM
Peter Kirkpatrick <pakirk@[EMAIL PROTECTED]
> writes:
> 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.
Use wildcards:
=COUNTIF(a:b, "*H*")
where a:b is your data table.
--
Thomas A. Russ, USC/Information Sciences Institute
