Is there a function or formula similar to SUMIF that will work for average,
median, & mode?

I have an array of numbers with corresponding values similar to the following

Nbhd Size
3401 .23
3401 .25
3401 .28
3402 .20
3402 .21
3402 .29

The difficulty is there are hundreds of neighborhoods and thousands of size
values in the array. There is a serious time crunch and the task is too
labor intensive to complete in the time allotted.

Does anyone have any suggestions?

Thanks,

JohnU