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

Hi. Thanks for looking into this. I think the problem may be with the portion of the formula that I need in each of these median formulae (IF(Data!$I$3:$I$1321<>""). Since I have different property sets that I put into this spreadsheet--all with different numbers of rows--I need the formulae to be able to account for that and not "count" any of the blank rows in the Data tab. This is how the original spreadsheet is set up that I sent you (reattached).

Having this in my Totals - Grocery and my Totals - Grocery; Non-Publix works, but for some reason it doesn't when it comes to Totals - Non-Grocery. For some reason, adding that in there looks like it returns the median of all the properties, which is not what I'm looking for.

I do need the formula to have in there those blanks. Any ideas on how to structure it?

Thanks so much for your help!!