Thread: Define variable range input for SUM() function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default Define variable range input for SUM() function
Try it like this:

=SUM(F6:INDEX(F6:I6,F4))

If F4 is an empty cell the entire range will be calculated.

--
Biff
Microsoft Excel MVP


"JeffC" wrote in message
...
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