Average with multiple criteria, but w/ the option to select All in any of them

[cacos]

Hi everyone


Hopefully someone has a better idea on how to handle the following: I have a sheet with scores rated by different users and it has 6 columns of demographic data.

On the other hand I have 6 comboboxes that define the 6 criteria, only that in any of them there's also the option to select "All" and thus skipping the previous criteria.


My question is: I have to average those scores, my problem is handling the "All" conditions.


Here's an example: https://docs.google.com/open?id=0B9nov_b3A5SvZFdmRFlHTzhJQkE


Sheet3 is where the data is

 

[Montrey]

Try using =Sumifs(

Then for Criteria, use "*?"

 

[cacos]

Yup that was it, replaced the criteria with an IF and that condition. Thanks!