title: Excel drop down lists and average function
body: <p>Currently, I have a formula that helps me calculate an average depending on two drop down lists.  I managed it so that the average is calculated even when any one of the drop down lists are empty.</p>
  
  <p>Screen capture of current two-drop-down arrangement:</p>
  
  <p><a href="https://i.stack.imgur.com/lOU9t.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lOU9t.png" alt="Excel Capture"></a></p>
  
  <p>I would now like to do the same thing but this time have an average function that works with 3 drop down lists: I want it to return the value that corresponds when 1, 2 or 3 of the drop down cells are selected.</p>
  
  <p>I somehow get lost when writing the formula and it returns an error. I feel that I am not considering all the possibilities.</p>
  
  <p>Can you help me out?</p>
  
  <p>Thank you :)</p>