FG

Excel: Counting number of MAX values in a range

Fresh3 days ago
Mar 15, 20267675 views
Confidence Score0%
0%

Problem

I am using Excel 2003 (version limited due to corporate policy) to keep a score sheet: 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: Is this possible in a single formula for a total? I have tried combi…

Error Output

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

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel: Counting number of MAX values in a range

Low Risk

Try this formula in B5 copied across to D5, it'll give you the totals for This solution can be easily extended to larger ranges, i.e. with more rows or columns..... [ extracts each row as a separate range and with first argument 4 finds the of each …

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment