> Actually, I am sorry for not being specific enough.  Your system works on
a
> line by line basis, whether or not 'Titanic' won that SPECIFIC award, but
I
> am looking for one equation at the bottom of my sheet to act as a summary
> tally.  Let me elaborate on the setup:  In column A, I have a list of the
> category awards; each has the nominees underneath.  In column B, I will
> enter an 'x' next to the nominee who ends up winning the award for that
> category.  Example:  A1: Best Actress, A2: Kate Winslet (Titanic), A3:
> Helena Bonham Carter (The Wings of the Dove), A4: Judi Dench (Mrs.
Brown),
> A5: Pam Grier (Jackie Brown), A6: Helen Hunt (As Good As It Gets).  In
the
> instance of Kate Winslet winning Best Actress, I will place an 'x' in
cell
> B2.  I will have all the award categories listed in column A, and if a
> nominee wins, I will mark it with an 'x' in coumn B.  I want my running
> tally at the bottom to count all the 'x' s for every film that will be up
> for a Best Picture Award (I will have cells in Column A at the bottom
which
> denote the titles for which I will be creating the corresponding Oscar
> Totals for in Column B).  So......if 'Titanic' were to win 5 awards
total,
> I want my equation to count all the 'x' s in column B that correspond
with
> text contained within the cells in column A that will read 'Titanic'
(such
> that it generates the # 5).  Does that make sense?  Thanks
> 
> Karen
> 
> Bob Umlas  wrote in article <34CE4DA9.64BE@kpmg.com>...
> > Karen Feigenbaum wrote:
> > > 
> > > I am looking to do a COUNTIF where the criterion for counting will be
a
> > > text string contained WITHIN the cell, but not encompassing the
entire
> > > cell's text.  I am setting up a spreadsheet to handle a pool which I
am
> > > running for the Academy Awards, and I want to be able to count how
many
> > > Oscars each picture wins - the name of the picture will be included
> within
> > > every nomination cell (e.g. under Best Actress, one nomination will
> read
> > > 'Kate Winslet (Titanic)').  In the case of my example, I want to be
> able to
> > > count the number of x's marked in the 'win' column (Column B) based
on
> > > whether or not a name 'Titanic' is contained in the 'nomination'
column
> > > (Column A).  Anyone have any ideas???  Thanks.
> > > 
> > > Karen Feigenbaum
> > ---------------------------------------
> > If I understand you, you want, say in column C, the # of x's in B if A
> > contains the text Titanic?
> > if that's so, enter in C1:
> >
>
=IF(NOT(ISERROR(FIND("titanic",A1))),LEN(B1)-LEN(SUBSTITUTE(B1,"x","")),0)
> > 
> > and fill down
> > ---------------------------------------
> > Bob Umlas, KPMG Peat Marwick, Excel MVP
> > 
> 


Use:

=SUM(IF(ISERROR(SEARCH("*Titanic*",A1:A10)),0,SEARCH("*Titanic*",A1:A10))*(B
1:B10="x"))

with A1:A10 and B1:B10 as example ranges.

Hold down the Ctrl and Shift keys when entering this formula.

David Hager