Spreadsheet: 888413d1738890640-dynamic-indirect-formula-with-two-countif-formula-results-in-one-cell-example-2
Sheet: (Sheet33)

Abbr. | Team | Nickname | Conference | Tm | Opp | TEAM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OPPONENT
 |  |  |  |  |  | FG | FGA | FG % | 3P | 3PA | 3P% | FT | FTA | FT% | ORB | TRB | AST | STL | BLK | TOV | PF |  | FG | FGA | FG % | 3P | 3PA | 3P% | FT | FTA | FT% | ORB | TRB | AST | STL | BLK | TOV | PF
AC | [NAME] | Wildcats | WAC
AF | Air Force | Falcons | MWC
Ak | Akron | Zips | MAC
Ala | Alabama | [NAME] | SEC
Ala AM | Alabama A&M | bulldogs | SWAC
[NAME] | Alabama State | Hornets | SWAC
Alb | Albany (NY) | Great Danes | America East
Alc St | Alcorn State | Braves | SWAC
Amer | American | Eagles | [NAME]
AP | [NAME] | Governors | A-Sun
[NAME] | Appalachian State | Mountaineers | Sun Belt
Ari | Arizona | Wildcats | Big 12
[NAME] | Arizona State | Sun Devil's | Big 12
Ark | Arkansas | Razorbacaks | SEC
[NAME] | Arkansas-Pine Bluff | Golden Lions | SWAC
[NAME] | Arkansas State | Red Wolves | Sun Belt
Army | Army | Black Knights | [NAME]
Aub | Auburn | Tigers | SEC
Baylor | Baylor | Bears | Big 12
BC | Boston College | Eagles | ACC
BC | Bethune-Cookman | Wildcats | SWAC
Bel | Belmont | [NAME] | Missouri Valley
[NAME] | Bellarmine | Knights | A-Sun
BGS | Bowling Green State | Falcons | MAC
Bing | [NAME] | Bearcats | America East
[NAME] | Bradley | Braves | Missouri Valley
[NAME] | [NAME] | Bears | Ivy
Bryant | Bryant | bulldogs | America East
BS | [NAME] | Cardinals | MAC
BS | Boise State | Broncos | Mountain West
BU | Boston University | Terriers | [NAME]
[NAME] | Bucknell | [NAME] | [NAME]
Buf | Buffalo | Bulls | MAC
But | Butler | bulldogs | Big East
BYU | [NAME] | Cougars | Big 12
C Ark | Central Arkansas | Bears | A-Sun
C Conn St | Central Connecticut State | Blue Devils | Northeast
C Mi | Central Michigan | Chippewas | MAC
Cal | California | Golden Bears | ACC
[NAME] | California Baptist | Lancers | WAC
Camp | Campbell | Fighting Camels | Coastal
Can | Canisius | Golden Griffins | MAAC
[NAME] | [NAME] | Buccaneers | Big South
[NAME] | Chattanooga | [NAME] | Southern
[NAME] | Chicago State | Cougars | Northeast
[NAME] | Cincinnati | Bearcats | Big 12
Cit | The Citadel | Bulldogs | Southern
Clemson | Clemson | Tigers | ACC
[NAME] | Cleveland State | Vikings | Horizon
CLT | Charlotte | 49ers | American
CO | Colorado | Buffaloes | Big 12
[NAME] | Colorado State | [NAME] | Mountain West
Coa Car | Coastal Carolina | Chanticleers | Sun Belt
Col of C | College of Charleston | Cougars | Coastal
Colgate | Colgate | Raiders | [NAME]
Colum | Columbia | Lions | Ivy
[NAME] | Coppin State | Eagles | MEAC
Corn | Cornell | Big Red | Ivy
CP | [NAME] | Mustangs | Big West
Creigh | Creighton | Bluejays | Big East
[NAME] | Cal State Bakersfield | Roadrunners | Big West
CS Full | Cal State [NAME] | Titans | Big West
CS North | Cal State Northridge | Matadors | Big West
Dart | Dartmouth | Big Green | Ivy
[NAME] | [NAME] | Wildcats | Atlantic 10
Day | Dayton | Flyers | Atlantic 10
Del | Delaware | Blue Hens | Coastal
Del St | Delaware State | Hornets | MEAC
Den | Denver | Pioneers | Summit
[NAME] | [NAME] | Blue Demons | Big East
[NAME] | Detroit Mercy | Titans | Horizon
Drake | Drake | Bulldogs | Missouri Valley
Drex | Drexel | Dragons | Coastal
Duke | Duke | Blue Devils | ACC
Duq | Duquesne | Dukes | Atlantic 10
E Car | East Carolina | Pirates | American
E Illi | Eastern Illinois | Panthers | Ohio Valley
E Ken | Eastern Kentucky | Colonels | A-Sun
E Mich | Eastern Michigan | Eagles | MAC
E Ten St | East Tennessee State | Buccaneers | Southern
E TX AM | East Texas A&M | Lions | Southland
E Wash | Eastern Washington | Eagles | Big Sky
Elon | Elon | Phoenix | Coastal
[NAME] | Evansville | Purple Aces | Missouri Valley
Fair | Fairfield | Stags | MAAC
FDU | FDU | Knights | Northeast
FGC | Florida Gulf Coast | Eagles | A-Sun
FIU | Florida International | Panthers | C-USA
FL | Florida | Gators | SEC
FL AM | Florida A&M | Rattlers | SWAC
FL Atl | Florida Atlantic | Owls | American
Ford | [NAME] | [NAME] | Atlantic 10
Fres St | Fresno State | Bulldogs | Mountain West
FSU | Florida State | Seminoles | ACC
Furm | Furman | Paladins | Southern
[NAME] | Gardner-Webb | Runnin' Bulldogs | Big South
GA | Georgia | Bulldogs | SEC
GA S | Georgia Southern | Eagles | Sun Belt
GA St | Georgia State | Panthers | Sun Belt
GA Tch | Georgia Tech | Yellow Jackets | ACC
GM | [NAME] | Patriots | Atlantic 10
Gonz | Gonzaga | Bulldogs | West Coast
Gramb | Grambling | Tigers | SWAC
Gran Can | Grand Canyon | Lopes | WAC
Green Bay | Green Bay | Phoenix | Horizon
G'town | Georgetown | Hoyas | Big East
GW | [NAME] | Revolutionaries | Atlantic 10
Hamp | Hampton | Pirates | Coastal
Harvard | Harvard | Crimson | Ivy
HI | Hawaii | Rainbow Warriors | Big West
Hof | Hofstra | Pride | Coastal
Holy C | Holy Cross | Crusaders | [NAME]
Hou | Houston | Cougars | Big 12
Hou Chr | Houston Christian | Huskies | Southland
[NAME] | [NAME] | [NAME] | MEAC
HP | High Point | Panthers | Big South
IA | Iowa | Hawkeyes | Big Ten
[NAME] | Iowa State | Cyclones | Big 12
ID | Idaho | Vandals | Big Sky
ID St | Idaho State | Bengals | Big Sky
IL | Illinois | Fighting Illini | Big Ten
[NAME] | Illinois-Chicago | Flames | Missouri Valley
IL St | Illinois State | Redbirds | Missouri Valley
IN | Indiana | Hoosiers | Big Ten
IN St | Indiana State | Sycamores | Missouri Valley
Incar | Incarnate Word | Cardinals | Southland
Iona | Iona | Gaels | MAAC
IU Indy | IU Indy | [NAME] | Horizon
[NAME] | Jackson State | Tigers | SWAC
Jax | Jacksonville | [NAME] | A-Sun
[NAME] | [NAME] | Gamecocks | C-USA
JMU | [NAME] | Dukes | Sun Belt
Kan City | Kansas City | Roos | Summit
[NAME] | [NAME] | Owls | C-USA
[NAME] | [NAME] | Golden Flashes | MAC
KS | Kansas | Jayhawks | Big 12
[NAME] | Kansas State | Wildcats | Big 12
KY | Kentucky | Wildcats | SEC
LA | Louisiana | [NAME]' Cajuns | Sun Belt
[NAME] | [NAME] | Explorers | Atlantic 10
LA St | Louisiana State | Tigers | SEC
LA Tch | Louisiana Tech | Bulldogs | C-USA
Lafay | Lafayette | Leopards | [NAME]
LA-M | Louisiana-Monroe | Warhawks | Sun Belt
Lamar | Lamar | Cardinals | Southland
[NAME] | Long Beach State | Beach | Big West
Le Moy | Le Moyne | [NAME] | Northeast
Lehigh | Lehigh | Mountain Hawks | [NAME]
[NAME] | Liberty | Flames | C-USA
Linden | Lindenwood | Lions | Ohio Valley
Lips | Lipscomb | Bisons | A-Sun
[NAME] | Little Rock | Trojans | Ohio Valley
LIU | Long Island University | Sharks | Northeast
Long | Longwood | Lancers | Big South
[NAME] | Louisville | Cardinals | ACC
[NAME] | Loyola (IL) | Ramblers | Atlantic 10
[NAME] | Loyola (MD) | Greyhounds | [NAME]
[NAME] | Loyola Marymount | Lions | West Coast
Manh | Manhattan | Jaspers | MAAC
Marist | Marist | Red Foxes | MAAC
Marq | Marquette | Golden Eagles | Big East
Marsh | [NAME] | Thundering Herd | Sun Belt
McNee | McNeese State | Cowboys | Southland
MD | Maryland | Terrapins | Big Ten
MD BC | Maryland-Baltimore County | Retrievers | America East
MD ES | Maryland-Eastern Shore | Hawks | MEAC
ME | Maine | Black Bears | America East
[NAME] | Memphis | Tigers | American
Mercer | Mercer | Bears | Southern
Mercy | Mercyhurst | Lakers | Northeast
[NAME] | Merrimack | Warriors | MAAC
MI | Michigan | Wolverines | Big Ten
[NAME] | Michigan State | Spartans | Big Ten
[NAME] | Miami (FL) | Hurricanes | ACC
[NAME] | Miami (OH) | RedHawks | MAC
Mid Ten | Middle Tennessee | Blue Raiders | C-USA
Milw | Milwaukee | Panthers | Horizon
MN | Minnesota | Golden Gophers | Big Ten
MO | Missouri | Tigers | SEC
MO St | Missouri State | Bears | Missouri Valley
Mon | Monmouth | Hawks | Coastal
More St | Morehead State | Eagles | Ohio Valley
[NAME] | Morgan State | Bears | MEAC
MS | Mississippi | Rebels | SEC
[NAME] | Mississippi State | Bulldogs | SEC
[NAME] | Mississippi Valley State | Delta Devils | SWAC
MSM | Mount St. Mary's | Mountaineers | MAAC
MT | Montana | Grizzlies | Big Sky
MT St | Montana State | Bobcats | Big Sky
[NAME] | [NAME] | Racers | Missouri Valley
N AL | North Alabama | Lions | A-Sun
N AZ | Northern Arizona | Lumberjacks | Big Sky
N CO | Northern Colorado | Bears | Big Sky
N East | Northeastern | Huskies | Coastal
N FL | North Florida | Ospreys | A-Sun
N IA | Northern Iowa | Panthers | Missouri Valley
N IL | Northern Illinois | Huskies | MAC
N KY | Northern Kentucky | Norse | Horizon
N TX | North Texas | Mean Green | American
N Western | Northwestern | Wildcats | Big Ten
Navy | Navy | Midshipmen | [NAME]
NC | North Carolina | Tar Heels | ACC
NC AT | North Carolina A&T | Aggies | Coastal
NC C | North Carolina Central | Eagles | MEAC
[NAME] | NC State | Wolfpack | ACC
ND | North Dakota | Fighting Hawks | Summit
[NAME] | North Dakota State | [NAME] | Summit
NE | Nebraska | Cornhuskers | Big Ten
New O | New Orleans | Privateers | Southland
NH | New Hampshire | Wildcats | America East
Nia | [NAME] | [NAME] | MAAC
[NAME] | Nicholls State | Colonels | Southland
NJIT | NJIT | Highlanders | America East
NM | New Mexico | Loboes | Mountain West
NM St | New Mexico State | Aggies | C-USA
No Da | Notre Dame | Fighting Irish | ACC
[NAME] | Norfolk State | Spartans | MEAC
NV | Nevada | [NAME] | Mountain West
NW St | Northwestern State | Demons | Southland
O Dom | Old Dominion | Monarchs | Sun Belt
Oak | Oakland | Golden Grizzlies | Horizon
OH | Ohio | Bobcats | MAC
OH St | Ohio State | Buckeyes | Big Ten
OK | Oklahoma | Sooners | SEC
OK St | Oklahoma State | Cowboys | Big 12
Omaha | Omaha | Mavericks | Summit
OR | Oregon | Ducks | Big Ten
OR St | Oregon State | Beavers | West Coast
Oral R | Oral Roberts | Golden Eagles | Summit
PA | Pennsylvania | Quakers | Ivy
Pac | Pacific | Tigers | West Coast
[NAME] | Penn State | Nittany Lions | Big Ten
Pepp | Pepperdine | Waves | West Coast
PFW | Purdue Fort Wayne | Mastodons | Horizon
Pit | Pittsburgh | Panthers | ACC
Port | Portland | Pilots | West Coast
Port St | Portland State | Vikings | Big Sky
Prairie | Prairie View | Panthers | SWAC
Presby | Presbyterian | [NAME] | Big South
Prince | Princeton | Tigers | Ivy
Provi | Providence | Friars | Big East
Purdue | Purdue | Boilermakers | Big Ten
Q NC | Queens (NC) | Royals | A-Sun
[NAME] | Quinnipiac | Bobcats | MAAC
[NAME] | Radford | Highlanders | Big South
RI | Rhode Island | [NAME] | Atlantic 10
[NAME] | [NAME] | Owls | American
Rich | Richmond | Spiders | Atlantic 10
Rider | Rider | Broncos | MAAC
[NAME] | [NAME] | Colonials | Horizon
Rut | Rutgers | Scarlet Knights | Big Ten
S Ala | South Alabama | [NAME] | Sun Belt
S Cal | Southern California | Trojans | Big Ten
S Car | South Carolina | Gamecocks | SEC
S Car St | South Carolina State | Bulldogs | MEAC
S Car USt | South Carolina Upstate | Spartans | Big South
S FL | South Florida | Bulls | American
S IL | Southern Illinois | Salukis | Missouri Valley
S IL Ed | Southern Illinois-Edwardsville | Cougars | Ohio Valley
S IN | Southern Indiana | Screaming Eagles | Ohio Valley
S MS | Southern Mississippi | Golden Eagles | Sun Belt
S UT | Southern Utah | Thunderbirds | WAC
Sac He | [NAME] | Pioneers | MAAC
Sac St | Sacramento State | Hornets | Big Sky
[NAME] | [NAME] | Bearkats | C-USA
Samf | [NAME] | Bulldogs | Southern
San Cl | Santa Clara | Broncos | West Coast
San D | San Diego | Toreros | West Coast
[NAME] | San Diego State | [NAME] | Mountain West
San F | San Francisco | Dons | West Coast
[NAME] | San Jose State | Spartans | Mountain West
SD | South Dakota | Coyotes | Summit
[NAME] | South Dakota State | Jackrabbits | Summit
SE LA | Southeastern Louisiana | Lions | Southland
SE MO St | Southeast Missouri State | RedHawks | Ohio Valley
Sea | Seattle | RedHawks | WAC
[NAME] | [NAME] | Pirates | Big East
SFA | [NAME] | Lumberjacks | Southland
Siena | Siena | Saints | MAAC
SMU | Southern Methodist | Mustangs | ACC
South | Southern | [NAME] | SWAC
[NAME] | St. Bonaventure | Bonnies | Atlantic 10
[NAME] | [NAME] (PA) | Red Flash | Northeast
St John | St. John's (NY) | Red Storm | Big East
St Jos | [NAME] | Hawks | Atlantic 10
[NAME] | Saint Louis | Billikens | Atlantic 10
[NAME] | [NAME] (CA) | Gaels | West Coast
[NAME] | [NAME] | Peacocks | MAAC
St Thom | St. Thomas | Tommies | Summit
[NAME] | Stanford | Cardinal | ACC
Stet | [NAME] | Hatters | A-Sun
Stone | Stonehill | Skyhawks | Northeast
Stony | [NAME] | Sea Wolves | Coastal
Syrac | Syracuse | Orange | ACC
[NAME] | [NAME] | Texans | WAC
TCU | TCU | [NAME] | Big 12
Tem | Temple | Owls | American
TN | Tennessee | Volunteers | SEC
TN Mart | Tennessee-Martin | Skyhawks | Ohio Valley
TN St | Tennessee State | Tigers | Ohio Valley
TN Tch | Tennessee Tech | Golden Eagles | Ohio Valley
Tol | Toledo | Rockets | MAC
[NAME] | Towson | Tigers | Coastal
Troy | Troy | Trojans | Sun Belt
Tulane | Tulane | [NAME] | American
Tulsa | Tulsa | Golden Hurricane | American
TX | Texas | Longhorns | SEC
TX AM | Texas A&M | Lions | Southland
TX AM CC | Texas A&M-Corpus Christi | Islanders | Southland
TX RGV | Texas-Rio Grande Valley | [NAME] | Southland
TX S | Texas Southern | Tigers | SWAC
[NAME] | Texas State | Bobcats | Sun Belt
[NAME] | Texas Tech | Red Raiders | Big 12
U MA | Massachusetts | Minutemen | Atlantic 10
U MA L | Massachusetts-Lowell | River Hawks | America East
UAB | UAB | Blazers | American
[NAME] | [NAME] | Aggies | Big West
UC Irv | UC [NAME] | Anteaters | Big West
UC Riv | UC Riverside | Highlanders | Big West
UC SB | UC Santa Barbara | Gauchos | Big West
UC SD | UC [NAME] | Tritons | Big West
UCF | UCF | Knights | Big 12
UCLA | UCLA | [NAME] | Big Ten
UConn | Connecticut | Huskies | Big East
UNC A | UNC Asheville | Bulldogs | Big South
UNC G | UNC Greensboro | Spartans | Southern
UNC W | [NAME] | Seahawks | Coastal
UNLV | Nevada-Las Vegas | Rebels | Mountain West
UT | Utah | Utes | Big 12
UT A | UT Arlington | Mavericks | WAC
UT St | Utah State | Aggies | Mountain West
UT Tch | Utah Tech | Trailblazers | WAC
UT Val | Utah Valley | Wolverines | WAC
UTEP | UTEP | Miners | C-USA
UTSA | UTSA | Roadrunners | American
VA | Virginia | Cavaliers | ACC
VA Tch | [NAME] | Hokies | ACC
Valp | Valparaiso | Beacons | Missouri Valley
Vand | [NAME] | Commodores | SEC
VCU | Virginia Commonwealth | [NAME] | Atlantic 10
Vill | Villanova | Wildcats | Big East
VMI | Virginia Military Institute | Keydets | Southern
VT | Vermont | Catamounts | America East
W Car | Western Carolina | Catamounts | Southern
W GA | West Georgia | Wolves | A-Sun
W IL | Western Illinois | Leathernecks | Ohio Valley
W KY | Western Kentucky | Hilltoppers | C-USA
W MI | Western Michigan | Broncos | MAC
W&M | William & Mary | Tribe | Coastal
WA | Washington | Huskies | Big Ten
[NAME] | Washington State | Cougars | West Coast
Wagner | Wagner | Seahawks | Northeast
[NAME] | Weber State | Wildcats | Big Sky
WF | Wake Forest | [NAME] | ACC
WI | Wisconsin | Badgers | Big Ten
Wich | Wichita State | Shockers | American
Wint | Winthrop | Eagles | Big South
Woff | Wofford | Terriers | Southern
[NAME] | [NAME] | Raiders | Horizon
WV | West Virginia | Mountaineers | Big 12
WY | Wyoming | Cowboys | Mountain West
Xav | Xavier | Musketeers | Big East
Y St | [NAME] | Penguins | Horizon
Yale | Yale | Bulldogs | Ivy