Excel Excel Help

[CONFUSED.COM]

Hi

I have a tennis spreadsheet and I need it to count up some data for me.

Please see attached example..

LOCATIONTOURNAMENTTOURNAMENTINFO Player Name Player NameWTALocationTournamentDateSurface/CourtRoundPlayer 1PriceSet scorePlayer 219Stuttgart, Germany[font=Arial, sans-serif]Porsche Tennis Grand Prix[/font]April 27 - May 3Outdoors/ClayFINALKUZNETSOVA .S 1.652v0SAFINA .D 21Rome, Italy[font=Arial, sans-serif]Internazionali BNL d'Italia[/font]May 3-9Outdoors/ClayFINALSAFINA .D 1.932v0KUZNETSOVA .S26Paris, France[font=Arial, sans-serif]Roland Garros (GRAND SLAM)[/font]May 24 - June 7Outdoors/ClayFINALSAFINA .D 1.400v2KUZNETSOVA .S21Rome, Italy[font=Arial, sans-serif]Internazionali BNL d'Italia[/font]May 3-9Outdoors/ClayFINALKUZNETSOVA .S1.932v0SAFINA .D 26Paris, France[font=Arial, sans-serif]WIMBLEDON[/font]JULY 1-4Outdoors/ClayFINALSAFINA .D 1.400v2KUZNETSOVA .S

It shows 2 tennis players that have played each other over a season.

What I need is for excel to tell me how many matches Safina has won and how many times kuznetsova has won.



Any ideas?

Thanks in advance

 

[Rush]

Hello, slightly get the question but you should try taking a snapshot of the excel page then posting as the above seems a tad ambiguous