'If' statement help needed

Ollie1785 

Oh my, you may be "rusty in Excel skills" but you are clearly using more than the most basic functions. So far as layout is concerned, however, what you've done is not only ambitious but a bit confusing--as can happen--for somebody other than yourself. For myself, I just don't have time today to try to navigate through all the different relationships (even while realizing that to you they're obvious and clear).

But I do wish you well...I'll have this in the back of my mind all day. I suspect that if I do come back to you, it will be with some recommendation to change the whole approach, changing the input side of things to more of a database of the results of all of the teams' rounds, laid out as a simple flat file database rather than as a visual portrayal of an actual scorecard. That's just a suspicion, but it's because I'm constitutionally averse to pretty (but less functional) input sheets; Excel is really good at extracting data from a flat file database (or even from multiple but related flat file databases--i.e., a relational database) but we make it hard for ourselves when we set up the raw data in ways that mimic paper (or score-card) record keeping methods.