problem finding the median

[cwwineman]

I have two columns of data, one is the price per unit, the other is the quantity sold at that price. I'm trying to find the median selling price, but MEDIAN doesn't work correctly and I'm not sure how to tell the function to count each price the actual number of times it was sold.

I actually believe I've found a work-around for this problem - I sort by price and use a SUM function to figure out where the middle is...I just feel like there should be an easier way (for the future).

Thanks for your help in advance.

William