Quiz Score Sheet

Sensei1948 

Warning: this is simply playing with 365 and represents total overkill!  What I did with Lorenzo  data was to total, rank and sort by rank in a single formula.

This proved to be surprisingly difficult because the obvious ranking formulas RANK.EQ and COUNTIFS require range references and not arrays.  My final formula was

= LET(
    total, BYROW(score, Sumλ),
    rank,  MAP(total, Rankλ(total)),
    SORTBY(HSTACK(Team,total), rank)
  )

where the two lambda functions were defined in Name Manager to be

Rankλ 
= LAMBDA(arr, LAMBDA(x,1+SUM(SIGN(arr>x))))

Sumλ 
= LAMBDA(x, SUM(x));

The double LAMBDA is used to pass the total array and the specific instance to be ranked as separate parameters, with MAP generating individual values to be ranked.

Oops. I missed a trick there!  I do not need to rank the teams.  The sort will do that for me.  

= LET(
    total, BYROW(score, Sumλ),
    SORTBY(HSTACK(Team,total), total, -1)
  )

In fact, SORTBY is an effective way of determining the ranking!