Andy

Try the below..

1. Suppose you have data in Sheet1 with headers in row 1. From Sheet2 access
the menu DataFilterAutofilter and 'Copy to another location' .
In list range type Sheet1!A1:A31
In copy to type/select cell A1

2. In Sheet2 Type the headers in Row1.
B1 = OK
C1 = DI

3. In cell B2 of Sheet2 apply below formula and copy that to right column C2
and down rows as required

=SUMPRODUCT(--(Sheet1!$A$2:$A$31=$A2),--(Sheet1!$B$2:$B$31=B$1))


If this post helps click Yes
---------------
Jacob Skaria


"andy" wrote:

Dear all, i hope somene can help - because ive just pulled out my last hair
i'll tryto explain - in column A i have a list of 30 names (which may be
duplicated in some places) - in column B i have two possible entries against
each name "OK" or "DI"

What i would like to do is have a formula that would count the name and the
number of "OK" and "DI" together
I could then on a seperate sheet have the one name and the total of OK and
DI against the name

simple for some of u - but not for me - sorry

Regards

Andy the novice