Excel 2007 : Lookup Formula Help

Hello all,

I'm needing some help with building a formula to count the number of certain answers provided by each person. Here's an example:

Name_____Answer
Bob_______Yes
Bob_______No
Joe_______N/A
Joe ______No
Joe_______Yes
Jamie_____Yes
Josh______No
Josh______No

What I am needing to do is to have a forumula look up the name, then count the number of times they gave a certain answer. The resulting table would look something like this:

Name_____Yes_____No_____N/A
Bob________1_______1______ 0
Joe________1_______1_______1
Jamie______1_______0_______0
Josh_______0_______2_______0

The names in the original table may change, so I want it to look up the name, then count the number of times that name has a specific answer in the results table.

Thanks for any help you can provide!

~~ Tim