Why not make a pivot table?
Lots of info he

http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm
http://www.dicks-blog.com/archives/2...le-parameters/
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"LP" wrote in message
...
In Sheet1, I have 13 columns total (A = Location, B – M are Jan -
Dec)

A B C D E F
Location Jan Feb Mar Apr May
Hawaii 5 8 12 22 45
Denver 10 58 41 44 10
Hawaii 12 58 77 88 99



In Sheet2, Cell A1, B1 and C1 are manual input month fields and they
are expected to change randomly. For instance, tomorrow, A1 might be
Oct instead of Feb.

A1 B1 C1
Feb Mar Apr


In sheet2, is it possible to have Excel take the average of value in
Sheet1 based on location and the month set in A1, B1 and C1 ? For
example, Sheet2 would look like this:

A1 B1 C1 D1
Location Feb Mar Apr
Hawaii 8.5 44.5 55
Denver 10 41 44


Any thoughts will be greatly appreciated.

Thanks.

LP