Counting data based on multiplte criteria

I am trying to create a database. Need to pull data from one sheet to another only if the data meets several criteria.

IE database includes demographic information - need to pull data to another page if age>=18 and <65, ***= male and they live in Ohio.

Novice to excel and cannot find any help to solve this problem - have tried countif but can't figure out how to nest sever IF's into that function. ANY help would be appreciated.
Thanks

Hi there,

Assuming the first row is used for headings, you could enter this formula in cell D2 (change the True/False response accordingly) and fill down:

=IF(AND(A2>=18,A2<65,B2="Male",C2="Ohio"),"True","False")

or filter the data (Data > Filter > AutoFilter) and customise the fields (columns) as required.

HTH

Robert