title: Finding average of irregular number of rows in Excel
body: <p>I have a data like this:</p>
  
  <p><a href="https://i.stack.imgur.com/vVuQ3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vVuQ3.png" alt="enter image description here"></a></p>
  
  <p>I want to find the average salary of all employees- As, Bs, Cs and Ds. I would like to know if there is any short cut to do the same as the number of employees is very large in my dataset. I tried using if else, but it turned out to be impractical. Do let me know if the same can be done in any other programming language. </p>