Thread: AVG_IF with YTD array - too many arguements
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vulcan[_2_] Vulcan[_2_] is offline
external usenet poster
  
Posts: 1
Default AVG_IF with YTD array - too many arguements
A1 (current month), B2:M2 (Jan - Dec), B3:M10 (data).

I want to change the month in A1 to get an YTD average. If I use an
{AVG(if,(if,(if,(if))))} array I get a "too many arguments error."
Reply With QuoteReply With Quote