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

Hi, Glenn. Thanks. It looks like the same formula that I'm using, but there's something I'm obviously missing. I've attached the spreadsheet that I was referring to. The main problem is the median formula for non-grocery anchored centers on the 2nd tab.

Thanks for your help with this! You are a lifesaver!