I am trying to get an average depending on two drop down lists. But i would like to get an average even when the second drop down has no input in it.
The formula I use is a simple:
AVERAGEIFS with: average range depending on the number column, 1st drop down list range and the drop down list cell as a criteria1 and the same for the second one.
Unfortunately I get an error outcome when there is no data selected in the second drop down list.
How can i modify the formula? Here is a picture of what i have.