title: Formula to calculate wins and losses
body: <p>I am making an Excel spreadsheet for UFC data. The next thing I'd like to do is add a couple columns into a sheet to track the record of a fighter (wins, losses, draws and no contest) after each fight on the sheet.</p>
  
  <p>An example of the current data is as follows</p>
  
  <pre><code>fighter1, fighter2, fighter1outcome, fighter2 outcome    
  Michael Bisping, Luke Rockhold, w, l
  </code></pre>
  
  <p>Wins are always fighter1, losses are always fighter2 but there are some draws and no contests as well. </p>
  
  <p>Is there a formula that could check for every previous fight the fighter had before, check the outcome field and count the number of times it happened? I was looking at COUNTIF statements but I couldnt seem to get anywhere</p>
  
  <p>EDIT 1:
  it was suggested to share some of the data and expected outcomes in the original post, so here is the first 20 lines with expected win and loss for both fighters:</p>
  
  <pre><code>fight#, fightEventID,   fightFighter1,  fightFighter2,  fightFighter1outcome,   fightFighter2outcome, fighter1wins, fighter1losses, fighter2wins, fighter2losses    
  1,  1,  JasonDeLucia,   TrentJenkins,   w,  L, 0, 0, 0, 0    
  2,  1,  GerardGordeau,  TeilaTuli,  w,  L, 0, 0, 0, 0    
  3,  1,  KevinRosier,    ZaneFrazier,    w,  L, 0, 0, 0, 0    
  4,  1,  RoyceGracie,    ArtJimmerson,   w,  L, 0, 0, 0, 0    
  5,  1,  KenShamrock,    PatrickSmith,   w,  L, 0 ,0 ,0 ,0    
  6,  1,  GerardGordeau,  KevinRosier,    w,  L, 1, 0, 1, 0    
  7,  1,  RoyceGracie,    KenShamrock,    w,  L, 1, 0, 1, 0    
  8,  1,  RoyceGracie,    GerardGordeau,  w,  L, 2, 0, 2, 0    
  9,  2,  RoyceGracie,    MinokiIchihara, w,  L, 3, 0, 0, 0    
  10, 2,  JasonDeLucia,   ScottBaker, w,  L, 1, 0, 0, 0    
  11, 2,  RemcoPardoel,   AlbertaCerraLeon,   w,  L, 0, 0, 0, 0    
  12, 2,  OrlandoWiet,    RobertLucarelli,    w,  L, 0, 0, 0, 0    
  13, 2,  FrankHamaker,   ThaddeusLuster, w,  L, 0, 0, 0, 0    
  14, 2,  JohnnyRhodes,   DavidLevicki,   w,  L, 0, 0, 0, 0    
  15, 2,  PatrickSmith,   RayWizard,  w,  L, 0, 1, 0, 0    
  16, 2,  ScottMorris,    SeanDaugherty,  w,  L, 0, 0, 0, 0    
  17, 2,  RoyceGracie,    JasonDeLucia,   w,  L, 4, 0, 2, 0    
  18, 2,  RemcoPardoel,   OrlandoWiet,    w,  L, 1, 0, 1, 0    
  19, 2,  JohnnyRhodes,   FredEttish, w,  L, 1, 0, 0, 0    
  20, 2,  PatrickSmith,   ScottMorris,    w,  L, 2, 0, 2, 0
  </code></pre>