Count How Many Times a row has a high score

[boss429cj]

So, I have a chart in which A5:A24 has a list of team names. C5:C24 has the score for each team for one week. Each subsequent column (i.e. D5:DH24, E5:E24, etc) has scores for each of those weeks. But, I only want to tally the ones that were played on Saturday, not Tuesday. Obviously, once I have the equation for one I can redo it to include Tuesday and not Saturday. Does that make sense?


What I am trying to count, is how many times each team has the high score each week on Saturday. For example:

Attachment 722409

So I am trying to tally, as you can see in the image, that on Saturdays, Team 1 had the high score 1 time, Team 2 had it 1 times. But I want to do a calculation to do that. I've tried some MAXIFS, MAX, COUNTIFs and I just don't see to be doing something right.

Any help is appreciated.

[FlameRetired]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[boss429cj]

Sorry.....Here is the sample attachment.

So, I have a chart in which A5:A24 has a list of team names. C5:C24 has the score for each team for one week. Each subsequent column (i.e. D5:DH24, E5:E24, etc) has scores for each of those weeks. But, I only want to tally the ones that were played on Saturday, not Tuesday. Obviously, once I have the equation for one I can redo it to include Tuesday and not Saturday. Does that make sense?

What I am trying to count, is how many times each team has the high score each week on Saturday. For example:

So I am trying to tally, as you can see in the image, that on Saturdays, Team 1 had the high score 1 time, Team 2 had it 1 times. But I want to do a calculation to do that. I've tried some MAXIFS, MAX, COUNTIFs and I just don't see to be doing something right.

Any help is appreciated.

[FlameRetired]

In the attached I made a copy of Scores called Scores (2). In C5 of that sheet and filled down find this formula.

Please Login or Register  to view this content.

There may be a simpler way. The only way that I could think of to get an array of MAX values for each column was to use SUBTOTAL/OFFSET. The double reciprocation/IFERROR was to avoid counting zeros when they appear in any given row.

Let me know what you think.

[kvsrinivasamurthy]

Try this. Pl see file.
In B5 of sheet "Scores (3)" then copied across.

Please Login or Register  to view this content.

Pl note the changes header in Column B & C.

[boss429cj]

Thank you! This worked. I'm still a little confused as to what is actually happening here, but man......did what I needed it to when I applied it to the actual data. Thanks again!

[FlameRetired]

You are welcome. Glad to help.

Thank you for the feedback and marking your thread Solved.

[daboho]

Is this solved