extracting data using multiple conditions

Hi,   I've got a dataset which i want to summarise. in column 2 in the summary table below, i want to bring back a count of total number of instances were the following conditions are fulfilled in ...