Spreadsheet: 142358d1329791081-using-if-and-sum-between-2-sets-of-data-rankings
Sheet: Sheet1

[NAME] | Ranking | Ranking | [NAME]
kentucky | 1 | 1 | Kentucky |  |  | kentucky
syracuse | 2 | 2 | Syracuse |  |  | syracuse
missouri | 3 | 3 | Missouri |  |  | missouri
north carolina | 4 | 4 | Michigan State |  |  | north carolina
kansas | 5 | 5 | Kansas |  |  | kansas
michigan state | 6 | 6 | Duke |  |  | michigan state
duke | 7 | 7 | Ohio State |  |  | duke
ohio state | 8 | 8 | North Carolina |  |  | ohio state
baylor | 9 | 9 | Georgetown |  |  | baylor
georgetown | 10 | 10 | Marquette |  |  | georgetown
louisville | 11 | 11 | Baylor |  |  | louisville
florida | 12 | 12 | Louisville |  |  | florida
marquette | 13 | 13 | Wichita State |  |  | marquette
florida state | 14 | 14 | Florida |  |  | florida state
michigan | 15 | 15 | Michigan |  |  | michigan
[NAME] | 16 | 16 | Indiana |  |  | [NAME]
murray state | 17 | 17 | Temple |  |  | murray state
nevada | 18 | 18 | New Mexico |  |  | nevada
southern mississippi | 19 | 19 | Southern Mississippi |  |  | southern mississippi
new mexico | 20 | 20 | UNLV |  |  | new mexico
temple | 21 | 21 | Saint Louis |  |  | temple
wisconsin | 22 | 22 | Gonzaga |  |  | wisconsin
gonzaga | 23 | 23 | Wisconsin |  |  | gonzaga
wichita state | 24 | 24 | Creighton |  |  | wichita state
[NAME] | 25 | 25 | [NAME] |  |  | [NAME]
unlv | 26 | 26 | Florida State |  |  | unlv
virginia | 27 | 27 | [NAME] |  |  | virginia
creighton | 28 | 28 | California |  |  | creighton
vanderbilt | 29 | 29 | Notre Dame |  |  | vanderbilt
cincinnati | 30 | 30 | San Diego State |  |  | cincinnati
san diego state | 31 | 31 | [NAME] |  |  | san diego state
drexel | 32 | 32 | Virginia |  |  | drexel
[NAME] | 33 | 33 | Kansas State |  |  | [NAME]
indiana | 34 | 34 | Harvard |  |  | indiana
california | 35 | 35 | West Virginia |  |  | california
memphis | 36 | 36 | Iowa State |  |  | memphis
nevada | 37 | 37 | Alabama |  |  | [NAME]
[NAME] | 38 | 38 | [NAME] |  |  | harvard
harvard | 39 | 39 | Texas |  |  | washington
washington | 40 | 40 | [NAME] |  |  | west virginia
west virginia | 41 | 41 | Mississippi State |  |  | long beach state
long beach state | 42 | 42 | Memphis |  |  | colorado
colorado | 43 | 43 | Connecticut |  |  | iowa state
iowa state | 44 | 44 | Purdue |  |  | kansas state
kansas state | 45 | 45 | Cincinnati |  |  | xavier
xavier | 46 | 46 | Xavier |  |  | connecticut
connecticut | 47 | 47 | Iona |  |  | miami (FL)
miami (FL) | 48 | 48 | Middle Tennessee |  |  | ucf
ucf | 49 | 49 | Oral Roberts |  |  | weber state
weber state | 50 | 50 | Miami (FL) |  |  | arizona
arizona | 51 | 51 | Dayton |  |  | [NAME]
[NAME] | 52 | 52 | Washington |  |  | tulsa
tulsa | 53 | 53 | South Florida |  |  | new mexico state
new mexico state | 54 | 54 | Drexel |  |  | middle tennessee
middle tennessee | 55 | 55 | Belmont |  |  | davidson
davidson | 56 | 56 | Nevada |  |  | oral roberts
oral roberts | 57 | 57 | Long Beach State |  |  | bucknell
bucknell | 58 | 58 | [NAME] |  |  | belmont
belmont | 59 | 59 | Akron |  |  | cleveland state
cleveland state | 60 | 60 | Cleveland State |  |  | iona
iona | 61 | 61 | Bucknell |  |  | Mississippi Valley State
Mississippi Valley State | 62 | 62 | Texas-Arlington |  |  | Texas-Arlington
Texas-Arlington | 63 | 63 | Weber State |  |  | Akron
Akron | 64 | 64 | Vermont |  |  | [NAME]
[NAME] | 65 | 65 | Wagner |  |  | stony brook
stony brook | 66 | 66 | Mississippi Valley State |  |  | UNC-Asheville
UNC-Asheville | 67 | 67 | Norfolk State |  |  | savannah state
savannah state | 68 | 68 | UNC-Asheville |  |  | Alabama
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Texas
 |  |  |  |  |  | Mississippi State
 |  |  |  |  |  | Purdue
 |  |  |  |  |  | Dayton
 |  |  |  |  |  | South Florida
 |  |  |  |  |  | Vermont
 |  |  |  |  |  | Wagner
 |  |  |  |  |  | Norfolk State