title: What Google Sheets formula should I use to average values that are not empty and are unique?
body: <p>I have the next two tables:</p>
  <p><a href="https://i.stack.imgur.com/nL56R.png" rel="nofollow noreferrer">Table 1, on sheet called &quot;top1Data&quot;</a></p>
  <p><a href="https://i.stack.imgur.com/hvptb.png" rel="nofollow noreferrer">Table 2, on sheet called &quot;top1An&quot;</a></p>
  <p>I want to take all the unique champions from Table 1 and insert them into Table 2 (under Total), and then average their stats (kills, solokills).</p>
  <p>Note that more champions can be added in the future, so it has to check for non-empty cells.</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1s4Nc9v1OWEGniJv-nqwe099hf6qmOFSfSENFDE7pFNs/edit?usp=sharing" rel="nofollow noreferrer">You can find an editable copy of the Google Sheet here.</a></p>