Newbie to excel needs help

Hi All. Hope I'm posting this in the right forum. I tried a lot of different searches and kinda lost right now. But this looks like a great place to get help as I've already used it to start me off. So here's my first problem...lol

I am making a spreadsheet that will be rankings. Actually it is of football players for my fantasy football site. There are 5 staff members and each of us ranks the players. Naturally all are different. I created the rows and columns for all and figured out how to sort as to create individual pages for each. Since it's for a webpage, what I have done is save them as a csv then export the file to Word which then creates the tables for me and then i export that file to my Page Editor and all works well. Time consuming as I end up doing the sorts to create approximately 40 pages as we do this for 8 positions. My problem mainly is the formula for AVERAGES as these will be the default pages for each position.

Mainly the bottom tier players as we rank 60-80 players at each position. So some players do not have a ranking by certain staff members and the cell is blank. So the average with the formula I use is not truly divisible by 5 (# of members) as the zero skews the average. For any cell that is blank because of this I would like a constant value of either 61 or 81 which are the maximum players we rank depending on the position. That would give any player not ranked in the top 60 or 80 a constant. I hope you are following me and hate that I'm writing a novel, but I'm trying to explain in detail what I need and have done.

The best formula I have figured out so far is this one.

=SUM(G1:K1)/MAX(1,COUNT(G1:K1)-COUNTIF(G1:K1,61))

which is somewhat better as it eliminates the 0 value and say one staff member doesn't rank a player in the top 60..it will then only divide the total by the amount of the staff members who ranked him.

Example: Player A....Ranks 60, 58, not ranked, 55, 54...the way i have it the average is Sum of (60+58+55+54) / 4 = 56.75 What I would hope to do is assign that not ranked value to 61 and have it (60+58+61+55+54)/5= 57.6 This is a much truer rank. And it will make a difference with higher ranked players more so.

Is this possible to do? I've racked my brains for 5 hours now just on this and finally figured someone could help me. Again, sorry about the long post but I'm new to this and want it so you have as much info as I can provide. Thank You in advance.