Comparing multiple sets of columns for greater values

I am a bit OCD and decided to analyze my stats for a game I like to play.

The game consists of several rounds of play and all rounds are summed up to get the total score.

I have the formula for comparing two columns and counting when one is greater than the other.

Please Login or Register  to view this content.

Now I want to extend this and count the number of "perfect" games I've had; how many times did I win in round 1 and round 2 and round 3?

Sample Data:

R1 R2 R3 T1 R1 R2 R3 T2
351 521 448 1320 360 577 675 1612
663 825 795 2283 657 747 538 1942
346 770 638 1754 261 955 973 2189
498 497 679 1674 523 414 1021 1958

The first set data are the opponent's, the second mine.

Is this doable with built in functions or do I need a UDF?

Thanks in advance.

After playing around a lot with the formula, it seems this appears to do the trick for me.

Please Login or Register  to view this content.