combine column label with average value

[ivymike]

I don't know if anyone else will find this useful or not, but I like doing it once in a while -

Put a column label and the average (or max, or min, etc) value in the column in the same cell by entering a formula such as the following:

="My Label [alt+enter] average: " + text(average(B10:B200),"0&quot