Excel drop down lists and average function
<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>