by Peter Kirkpatrick <pakirk@[EMAIL PROTECTED]
>
Jun 8, 2007 at 07:11 AM
In article <ymimyzbs4sr.fsf@[EMAIL PROTECTED]
>, Thomas A. Russ
<tar@[EMAIL PROTECTED]
> wrote:
> 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.
Thanks, that solved the problem. Is there a way to count occurrences in
noncontiguous groups of cells?
