need help creating a summary from two columns of data in an excel file

I have a column for serial numbers and a pass/fail column.

I have created an additional column from the serial number column that gives me a list of the unique serial numbers contained with in the original serial number column.

What I would like to do now is:

1) Take all the pass/fail data and summarize it with two more columns next to the newly created unique serial number columns called Pass and another one called Failed.

     a) In the pass column I would like to total the number of times the unique serial number passed the test.

     b) In the failed column I would like to total the number of times the unique serial number failed the test.

Thanks for any help.

PS  If I have not made my self clear, please let me know and I will clarify.