=COUNTIF($J:$J,">"&J2)+COUNTIF($Q:$Q,">"&J2)+COUNTIF($X:$X,">"&J2)+COUNTIF($AE:$AE,">"&J2)+COUNTIF($AK:$AK,">"&J2)+COUNTIF($AQ:$AQ,">"&J2)+COUNTIF($AW:$AW,">"&J2)+COUNTIF($BC:$BC,">"&J2)+1
is my solution. i had to add and change some columns around, but basically it will count the number of occurrences that a value is greater than the cell of interest in all the applicable columns, and then add 1 to count for itself