title: How to skip a field in column using awk
body: <p>I have this data here:</p>
  
  <pre><code>Name,Team,First Test, Second Test, Third Test
  Tom,Red,5,17,22
  Joe,Green,3,14,22
  Maria,Blue,6,18,21
  Fred,Blue,2,15,23
  Carlos,Red,-1,15,24
  Phuong,Green,7,19,21
  Enrique,Green,3,16,20
  Nancy,Red,9,12,24
  </code></pre>
  
  <p>I would like to skip field 3 ($3) in row 6 when I'm finding the average of the First Test since it's a negative. </p>
  
  <p>How would I skip over that particular value and have all the fields still add up in the First column?</p>
  
  <p>I know that the next command skips over the whole row, is there a command that will skip a particular field?</p>
  
  <p>Thank you. </p>
  
  <p>EDIT</p>
  
  <p>Sorry. Here is how the output should look like, I already have the Averages of test two and three, just need help with the average for test one.</p>
  
  <pre><code>Average for Test 1: 5
  Average for Test 2: 15.75
  Average for Test 3: 22.125
  ---------------------------------
  </code></pre>