Quick and easy way is to use Pivot Table.
Before you start, create a range for your data
Look on the Data menu, select Pivot Tables. The Wizard will step you through the process.
Select the columns you want displayed, as well as the "Section" column, in your example "Able to Lock Up."
After you have the Pivot Table created with the wizard, a few more steps to clean it up.
such as setting rows to not total.
Then you can select the column title for "Able to Lock Up" ans select "Yes" The table will only sow "Yes"