Ok, so here is the problem. Given a sheet that has columns named "opponent; date; side played; result" and rows which give a name, date, etc, like this:

Name Date Side Played Result
Bob xyz White Win
Tim xyz Black Loss
Sally xyz White Win

I want to generate two more sets of data on a separate sheet. I'm such a chess fanatic that I want to keep track of how many games I've played against each opponent, and my win-loss stats against each; I also want to quickly compute my win percentage as each side.

Therefore I'd have one set of data that would have rows that read:

Opponent Games Played Wins Losses
Bob 1 1 0

Getting Opponent and Games Played is easy enough. I simply Count the number of times "Bob" shows up in the Name column from the previous sheet. But what I also want to do is count the number of times "Win" comes up, but ONLY IF "Bob" occurs in the same row. How on earth do I do that?

Figuring out win percentages is a similar problem, really. But none of the tutorials I've found online approach dealing with things this involved.

Thanks in advance.