I have 28 members that score points for each event that they participate during a ten week schedule. I have a SUM column for the total points accumulated. I also have another SUM column showing only the seven highest points scored. I also have a column using COUNT showing the number of events they have received points. I also have a standings (RANK) column.

Since all members do not participate in each week's event, the count numbers vary. So, I need to have another column that ranks the the standings where there are a minimum of 7 (COUNT) scores posted. I will call it a "Qualified Standings" column.

I want the final standings to only use the scores when there is a minimum of 7 posted, and after at least 7 scores are posted.

I hope I have explained this well enough for you to understand.