You are welcome..

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


"andy" wrote:

Francis & Jacob both works a treat for your answers, Ron - i dont really
understand pivots ( another failure for me) nor how to get graphs working
with them so i am going to use Francis method - it gives me 90% of what i
need but i will need to work out how to get the remaining - (not your
answers my requirments).

Thanks guys -

I may be back

regards

Andy francis (yes francis is family name)



"Francis" wrote:

Do I understand you correctly, you want to count the total number of OK and DI
for a given name? if yes

In Sheet2 ,
in A2, type the name
in B2, try the below formula
for the example below
=SUMPRODUCT(--(Sheet1!A2:A11=A2),--(Sheet1!B2:B11="OK")+(Sheet1!B2:B11="DI"))
this will give you 2 for the name Mike
name type
dave OK
mike OK
joey ok
ken DI
dave DI
ken OK
mike DI
ken DI
joey OK
joey OK
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"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