Hi,
I can't find out how to do this despite searching many posts and I think it
should be easy
I have a range of numbers forecast for each month
eg
jan feb march etc
pay 5 10 6
NI 2 4 3
Pen 3 3 3

Each month I would like to show the cumulative forecast figure for each line
which means the formula changes
eg (using the simple table above)
in february the formula for pay should be =sum(a2:a3)
in March it would be =sum(a2:a4) etc
Howe can I do this automatically so that if I had a cell that shows the
month I could change the month and that would change the formula so that it
picks up the new months data

I hope I have explained this well.

Thanks in anticipation


sum a range of cells