How to write an IF/Than formula to pull information into a summary sheet?

[Alex_Newell]

I am using a large amount of information and am trying to get rows that are flagged or marked with an X in column to populate a summary sheet within the same workbook. Can anyone help with how to accomplish this?

Thank you

[#2]

@Alex_Newell 

You don't need an IF..THEN formula for this. You need the FILTER function (which does require the most recent version of Excel).

Here's a video that explains its use. https://www.youtube.com/watch?v=9I9DtFOVPIg