Help to automate ranking of tied teams in sports scoring program

Ok

Have a look on sample 3 file.

What I done with is -Countif with X on M9 to M26.
This will bring it down to 70 or less instead stay on 72.

Column results Z and AA I put in if with ISNA.
Reason When Grid all blank get N/A on it. This will change to blank instead N/A.

Let me know if done it or not?

Cheers