I am using Excel 2003 (version limited due to corporate policy) to keep a score sheet:

```
A B C D
1 Round | Rita | Sue | Bob
------+------+-----+-----
2 1 | 5 | 3 | 4
3 2 | 2 | 2 | 5
4 3 | 3 | 1 | 3
```

What I want is for each person to have a total of winning rounds, with a tie awarded to both. So the total row should look something like this:

```
-------+------+-----+-----
5 Total | 2 | 0 | 2
```

Is this possible in a single formula for a total?

I have tried combinations of `CountIf`

and `Max`

but can't quite get the desired output.

My only other solution is to have a separate set of score columns: e.g `IF(B2=MAX(B2:D2),1,0)`

for each Round and then sum these for each person.

**EDIT:** To make it clear, I have a solution which involves adding extra columns. I am asking for solutions which allow formula(e) to be added to each existing person column to calculate the totals without adding any extra columns.