Median formula with multiple criteria (or not and) and partial text in a cell

Hi. I've been flying across Europe, working and all sorts of stuff. I finally got my head round this, this afternon. Try it now. I did complress the ranges back down to row 19 to help manual checking.