excel 2007 has some new functions that will do the selection for you. You can define the conditions from adjacent cells.
I used to do the same you did manually. Then figured it out. I used AVERAGEIF and COUNTIF (gives me the number of samples that I'm using for the average). I'll have to see if there is a MODEIF to expose the most common value (didn't know about mode until this thread).
I also have it figure out the cell breaks by puting in the break points from my map.