variable sum range

[DrJimmy]

Hi,

I want to be able to have a formula that sums a range of cells where by the starting point is known but the end point is variable number of columns to the left of the starting point.

The variable number is a function of the number of days between today and the start of the month.

This is so I can get a cummulative MTD value without having to change the formula - just the date.

Can anyone help?

Cheers

 

[Kiwiman]

Howzit

This is what I use - there are probably easier ways, but it works.

In particualr to your problem it is the Budget YTD value that is changeable in column J based on the month selected.

Using a combinationof index and indirect.

 

[DrJimmy]

Cheers for that. The final formula was SUM(A1:INDEX(A1:X1,,C5)), where A1:X1 was the total range that I wanted to look at and C5 had the variable column number where I wanted to SUM to.