title: Excel: Averaging the values from a set of rows, but only include them if they have a specific value in a column
body: <p>I'm looking for help dynamically averaging the column values of every item in an Excel table that has a given value in one of its columns. Specifically:</p>
  
  <p>I have an Excel sheet where each row represents an entity in a video game I am working on, and each column is a numerical value for different attributes on these entities. Movement Speed, Health, Attack Damage, etc. Each of these rows also has a column where I tag the row with the name of the class that this entity is a part of: "tank", "support", etc. This table has roughly a hundred items in it, and is likely to grow to two or three times that size. </p>
  
  <p>It looks something like this:</p>
  
  <p><a href="https://i.stack.imgur.com/HN0Ml.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HN0Ml.png" alt="enter image description here"></a></p>
  
  <p>What I would really like to do is have, on a separate tab, a table where each row represents one of the classes, and shows the average value of all of the entities that have that class in their "group" column. And I want it to automatically include new entities of that class as they are added to the first table. </p>
  
  <p>It would look something like this, where these values are automatically generated from the data in the first table (I have no problem manually entering the class names, I just need the numerical data to be driven):</p>
  
  <p><a href="https://i.stack.imgur.com/Gio5s.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Gio5s.png" alt="enter image description here"></a></p>
  
  <p>I imagine that the solution will be a complex, nested pile of <code>VLOOKUP</code>s and <code>MATCH</code>es and other Excel functions, but I am not really sure how to accomplish this. I didn't even know the proper terminology to search for existing answers to this question, so I hope that it isn't too redundant. Thanks very much for any advice you have!</p>
  
  <p>Version: I am using Excel 2013. </p>