Is there anyway to combine 'averageifs' and 'or'
Average score: xxxx
So if someone choose the dropdown of Year and Product only, it will only calculate the average of these two criteria only; if someone chosen 3 criteria, the averages core will narrow down 3 criteria so on and so forth.
How do I do that?
It's a little bit like
averageifs(2013, yeardata, A, productdata) or averageifs(2013, yeardata, A, productdata, UK, country), or.....
This question generated 19 answers. To proceed to the answers, click here.
This thread is current as of September 18, 2014.
For more resources for Microsoft Excel