Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

combine column label with average value

Thread starter ivymike
Start date Feb 18, 2002

Status: Not open for further replies.

Feb 18, 2002

ivymike

Mechanical

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