Thread: Define variable range input for SUM() function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JeffC JeffC is offline
external usenet poster
  
Posts: 15
Default Define variable range input for SUM() function
I'm still working through this... but why doesn't the following formula work?
=SUM(INDIRECT(INDEX(F6:I7,1,1):INDEX(F6:I7,1,F4))) ... where F4 equals an
integer representing a month/column in the range?
Reply With QuoteReply With Quote