Counting multiple instances and matching condition

[timtimba]

Hi,

I am in bit of a pickle and would appreciate some help.

Basically I have four columns and I have to test the values and if any of the values is true then I have to count them

I have name of stocks, the person who traded them, the time of trade and finally how many times it was traded.

Lets put it in real formatL
Name of stock = MSN
Person trading = joe blogg, any tom, guy pearce
Time of trade = 11am, 1130am, 1145am, 1130am
Taded = 4 times

So now I want in a column:
Joe blogg and Any Tom traded it same time = Check
joe blog traded it any time = no check
joe blogg and guy pearce traded it diff times = check

Currently I am using this formula but it doesnt work
First I count the number of times the stock was traded = =IF(N9>1,1,0)
Then I count if it is the same stock =IF(COUNTIF($R$9:$R$1067, R9)>1, 1,0)
Then I see if its the same person =IF(COUNTIF($U$9:$U$1067,U9)>1,1,0)
Finally I see if its the same time =IF(COUNTIF($T$9:$T$1067,T9)>1,1,0)

Now I set a coulumn with this =IF(X9=1, IF(S9=1, IF(V9=1, "No Check", IF(W9=1, "No Check", "Check"))))

Any ideas as this is not working ... cause I have found multiple instances whereby the same stock has been traded with diff persons but its not coming as check

 

[RonB1111]

Use the COUNTIFS formula which will test everything in a single formula.
Here's a link explaining it: Use COUNTIFS() to evaluate multiple count and criteria ranges | TechRepublic
It requires Excel version 2007 or higher.

If you still need help, please post some sample data show what is in each column and a sample of your expected results.