Sum a slice of a named range?

[LostInDaJungle]

So, I have a table that has the monthly sales in one column and the sales budgets in another column. Since monthly sales is a running total, it's easy to calculate current YTD. Sales Budgets is another thing entirely. We have Sales Budgets pre-written through December.

What I need is to be able to sum an array slice. SUM(myArray[1-5]) That way I could have the YTD budgets for the current month. How can I sum the first n members of a named range?

Budgets are in a named array called 'SalesBudgets_2012'

A single month's budget is retrievable with:

=INDEX(INDIRECT("SalesBudgets_" & DashYear),DashMonth)

DashYear is 2012, DashMonth is 5. Both of these are fed from a Drop Down list.

 

[Jonmo1]

Try the offset function

Offset(array,#rows,#cols,Height,Width)

If this returns the 1st cell you want in the sum
=INDEX(INDIRECT("SalesBudgets_" & DashYear),DashMonth)

Then this will sum a 5 cell verticle range beginning with that cell.
=SUM(OFFSET(INDEX(INDIRECT("SalesBudgets_" & DashYear),DashMonth),0,0,5,1))

 

[LostInDaJungle]

Thank you!

This works like a champ: =SUM(OFFSET(INDEX(INDIRECT("SalesBudgets_" & DashYear),DashMonth),0,0,DashMonth,1))