Hello,

I was wondering if it is possible to use multiple conditional statements in Excel to display data from a dataset.

For example, I have a dataset about demographic characteristics (e.g. age, education, job sector). Using the dataset, is there a function where I am able to display the percentage of people that are:
1. 30 years old AND
2. Completed university AND
3. Work in health care

Furthermore, does such function allow me to mix and match conditional statements?

The end goal is to have an interface where users can select as many variables in the dataset and see the percentage of people in the data that meet all the selected conditions.

Thank you in advance!