View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Sum of continous cell

Assuming your variable that changes each month is in cell B1, and assuming
the budgets from month to month are variable named such as Month1, you could
use:

=SUM(INDIRECT("Month1"):INDIRECT("Month"&B1))

Hope that helps.
--
John C


"Man" wrote:

I need to sum budget from month 1 to month "N", where "N" is a variable that
changes each month, but I don't want to change the sum formula, only the
variable that represents the month.