Glenn,

Thank you so much!! It works and I really appreciate it.

As a follow up question, imagine I had a lot of records with different grocery stores and non-grocery stores. If I wanted to find the median of just the grocery stores (Publix, Winn-Dixie, Whole Foods, Trader Joe's, etc.), how could I do that? I tried using the same formula as above and added all the ISNUMBER(SEARCH(G5,$C$2:$C$17)) for the different grocers, but than the formula became too long and it wouldn't work. I'm guessing there might be a way to do it using VLOOKUP. I would still need to not include the Under Construction properties. Then, if I wanted to not include the different grocers, and only pull the median of the non-grocery stores, I would guess I'd just use more of this IF($F$2:$F$17<>"Under Construction", but have it say the different grocers instead of Under Construction. There are about 25 different grocers, so I'm trying to use a formula that will work.

Thanks for all your help.