Conditional Average with Multiple Columns
 

Hello Excel Gurus !


In Sheet1, I have 13 columns total (A=Location, B - M are Months)

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


In Sheet2, A1, A2 and A3 are manual input of months

A B C
Feb Mar