I have a problem I would love some help with!

I have about 100 numbers in a column. I also have criteria in other
columns that classify the numbers into groups. I am curious if there
is any way to find the median of only SOME of the numbers in the
column.

For example:

A B C
city street 1600
city avenue 1400
town street 1500
village avenue 1700
city street 1900
city street 1200

Is there any formula I could put in a cell that would let me find the
median of the values of column C that meet the criteria of having
column A=city and column B = street (would be the median of 1600,
1900, and 1200, and would result in 1600)?

I have tried using sumproducts for the criteria aspect of it, but I
quickly got stuck.

If anyone has any ideas, I would love to hear them!

Thanks for your time. :)


--
thekovinc
------------------------------------------------------------------------
thekovinc's Profile: http://www.excelforum.com/member.php...o&userid=29378
View this thread: http://www.excelforum.com/showthread...hreadid=509159