View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LP LP is offline
external usenet poster
 
Posts: 12
Default 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