How to calculate a median from date selected data

[RogeratCCCC]

I would appreciate any suggestions for the following problem:

I have a large table of transaction data where each row includes a date and a price. From this data, I would like to form a summary table where each row summarizes the transactions for a month. Each row of the summary table should contain a column for the month summarized, a count of the number of transactions in that month, the average of the transaction amounts for that month, and the median of the transaction amounts for that month.

I can form the summary count and the transaction average with array formulas, but I can’t figure out how to create the median. Note that in this case, data needs to be selected from the original table, then sorted, and then the median selected. The Excel built in Median function has a limit of 30 arguments, so I’m not sure if I can use that or not.

Thanks in advance for any suggestions for how to calculate the median in this situation.