Excel formula debugging - Median calculation

I need help in proper formula formatting/syntax. I just haven’t been able to debug my formula to calculate a Median.

Here is a similar working formula that calculates an Average:

Formula:

Please Login or Register  to view this content.

I need to modify the above so it calculates a Median.

I’ve tested this simpler formula for proper format and it works:

Formula:

Please Login or Register  to view this content.

I need to replace "date_city!$I$2:$I$989" and "date_city!$E$2:$E$221" from the above Median formula with their corresponding code from the Average formula.

I tried the following code, but cannot find my errors. Probably incorrect parantheses or comma placement.

Formula:

Please Login or Register  to view this content.

Thanks in advance for any help.

Thanks for the reply, daddylonglegs. I made the changes you indicated (no quotes and no &'s), but the Median code still does not work.

Much thanks. Your help is greatly appreciated. The code you provided works great.