Inserting a number at the top of a range

[xzmike]

For example, in A1 I have number 1, in A2 I have number 2. In A3 I have the formula SUM(A1:A2). I want to insert a number in A1 and have the formula incude it. i.e. SUM(A1:A3). This cell now being in A4 due to the insertion.

I can insert the cell at the bottom SUM(A1:OFFSET(A4:,-1,0) but I can't figure out how do it at the top.

Thanks,
Mike

 

[WillR]

You maybe didn't get an answer to this as you posted in the Access forum as opposed to the Excel forum.

The only way to do something like you want wold be like this

Book1
	A	B	C	D
1	10
2	2
3	3
4	4
5
6
Sheet2

Putting =SUM(A1:A4) in Cell A1 will just create a circular reference

Hope this helps.