Thread: Calculate average based on user selection
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
P Sitaram P Sitaram is offline
external usenet poster
  
Posts: 4
Default Calculate average based on user selection
Assume your months are in A1:A12 and values in B1:B12, drop down in C1

=AVERAGE(B1:INDEX(B1:B12,MATCH(C1,A1:A12,0)))

Reply With QuoteReply With Quote