I have a spreadsheet like this...
............Mon....Tues.
Joe.......yes.......no
Joe.......yes.......yes
Joe.......no.........yes
Joe.......yes.........no
Sally.....no.........yes
Sally.....no..........no
Sally.....yes.......yes
Sally.....yes........no
Sally.....no.........yes
Sally.....yes........no
Sally.....no..........yes
Greg....yes.........no
Greg....no..........no


All the names in the first column are unique. I need to go through the whole spreadsheet and have a simple way to tell me how many yes's or no's each person has on each day of the week like this...
..............Mon..........................Tues.
Joe......yes=3...no=1..........yes=2...no=2
Sally....yes=3...no=4.........yes=4...no=3
Greg....yes=1...no=1.........yes=0...no=2


Is there some macro for this? The spreadsheet is too big to have to go through the whole thing manually trying to get this information.

thanks