Thread: AVG_IF with YTD array - too many arguements
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
barry houdini[_29_] barry houdini[_29_] is offline
external usenet poster
  
Posts: 1
Default AVG_IF with YTD array - too many arguements

Try

=AVERAGE(OFFSET(B3:B10,0,0,,MATCH(A1,B2:M2,0)))

I'm assuming that A1 just shows the month as text e.g. "Sep"


--
barry houdini
------------------------------------------------------------------------
barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=134991

Reply With QuoteReply With Quote