Using a drop down box - if 'all' or 'blank' is chosen then include all

Hello...   Please help, I'm lost.    I have a sheet with a lot of countifs and sumifs which gives a summary of performance of different people based on set criteria.    I also have a drop...