Excel 2016: Exclude a specific cell from a range when calculating a median

Hi, I'm new at this and really not a pro with Excel, so hope someone can help me out!  I'm pulling data from one workbook into another.  The path info is correct, but I'm trying to add totals from co...