Is there a formula to fill the summary sheet with just the people who are on leave?......

Thanks Andy