Hi All,

I have created a report that I extract from a MySQL database into Excel. I want to be able to filter the results of my report, how ever I do not want to use the regular Excel filter as it has limitations to how I can display my report. I have tried using the following formula:

=IF($S$4="-- Service Years --",IF($O$4="-- Education Level--",IF($K$4="-- Age Group --",IF($G$4="-- Race --",IF($C$4="-- Gender --",IF($S$3="-- Employment Type --",IF($O$3="-- Job Description --",IF($K$3="-- Manager --",IF($G$3="-- Cost Centre --",IF($C$3="-- Division --",COUNTIF(data_source[Category 1 Q1.1],"Strongly Agree"),COUNTIFS(data_source[Division],$C$3,data_source[Category 1 Q1.1],"Strongly Agree")),COUNTIFS(data_source[Cost Centre],$G$3,data_source[Category 1 Q1.1],"Strongly Agree")),COUNTIFS(data_source[Manager],$K$3,data_source[Category 1 Q1.1],"Strongly Agree")),COUNTIFS(data_source[Job Description],$O$3,data_source[Category 1 Q1.1],"Strongly Agree")),COUNTIFS(data_source[Employment Type],$S$3,data_source[Category 1 Q1.1],"Strongly Agree")),COUNTIFS(data_source[Gender],$C$4,data_source[Category 1 Q1.1],"Strongly Agree")),COUNTIFS(data_source[Race],$G$4,data_source[Category 1 Q1.1],"Strongly Agree")),COUNTIFS(data_source[Age Group],$K$4,data_source[Category 1 Q1.1],"Strongly Agree")),COUNTIFS(data_source[Education Level],$O$4,data_source[Category 1 Q1.1],"Strongly Agree")),COUNTIFS(data_source[Service Years],$S$4,data_source[Category 1 Q1.1],"Strongly Agree"))


The problem with this formula is:
It is currently only filtering on the last 2 results i.e. "Education Level" & "Service Years"
I can not apply multiple / random filters.
I need to be able as an example select a "Division", "Race", and get a result showing only results from those two criteria.
If I select only "Job Description" as an example I need to see all results with that Particular Job Description. And so on.

I hope I have explained this properly? Would really appreciate the help.

Some additional info is that each of my drop-down menus default values are as follows, and should therefore be treated as "No Value Selected" for that menu option.
-- Division --
-- Cost Centre --
-- Manager --
-- Job Description --
-- Employment type --
-- Gender --
-- Race --
-- Age Group --
-- Education Level --
-- Service Years --


A sample workbook is attached. Cell F9 is the only cell in the report that currently has the formula that I added to the forum. The other cell formulas are incorrect and I would still need to adjust these.