Tom and Steve

Thanks for the auto filter Tom got the unique list just like I wanted. However, I am using this formula in Sheet 2 cell 2 for the results in b2
=Countif(team payout!B:B,b2,team payout!E:E)

Team Payout is sheet 1 in my original post.

I get the error message "I've entered too many aruguments for this function" I've looked over your example and see not mistakes.

Ideas???
Once again

Thanks

Buddy