If you want the counts of A's and B's for each person listed in column A, you
can also create a Pivot table. The list must have a header row, say "Name" and
"Code"

Use Name as the row field, Code as the column field and either Name or Code as
the data field. Excel will automatically do a count, since the data is text.

On Mon, 29 Oct 2007 12:16:01 -0700, PAL wrote:

I have a 700 line spreadsheet, 2 columns). Column A has is a name (it is
concatenated from elsewhere) and column B is a value (A or B).

I made a list of all the unique names from the first column and placed it in
Column E. I would like to be able to look at the list of 700 and cound the
number of "A"s and "B"s

CarA A
CarB B
CarA B
CarA A

Here is what I tried:
=COUNT(IF((A$2:$A$701=$S13)*($F$2:$F$701="A"),$F$ 2:$F$701))

It doesn't work, I get 0's