Another way to try

Assuming the table is in cols A and B,
data from row2 down

With C1 left empty
Put in C2:
=IF(AND(COUNTIF($A$2:A2,A2)<2,B2="Yes"),1,"")
Copy C2 down

Then just put in say, D1: =SUM(C:C)
to return the desired result
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Bruce Norris" wrote in message
. ..
I'm drawing a blank on how to do this. I need a formula to count "Yes"
values per unique value in another colum. (see example)

In each record...
The first column (A) shows trip codes.
The second column (B) shows either "Yes" or blank.

I need a formula that counts all "Yes" values in column B per trip
code.

For example, using the data below, "2" would be the answer because 2
trip codes corresponded to "Yes".

Trip Covered
tr-24 Yes
tr-24 Yes
tr-24 Yes
tr-50
tr-50
tr-16 Yes
tr-16 Yes
tr-16 Yes
tr-16 Yes

It might help to know when "Yes" appears in a record of a particular trip
code,
it appears in each record of that code. No mixing.

Excel 2002

Thanks for your help!