Search for the first number in a column

Originally Posted by lans

Hi people,

I have the following problem and hope somebody has an answer.

I think the easiest way is to use the attachment as an example. Cell E7 has a formula in which I calculate the sum of cell E1 and E7. Later in cell E11 I calculate the sum of E7 and E11. I also have to calculate this manually. No my question is: how can I find the first number in the E-column above the cell with the formula. In other words. If I calculate cell E11, how can I automatically find cell E7 (the first number when you search upwards in the column). And for cell E19, how can I find the number in cell E16 which I need for calculating cell E19.

I hope it is clear and somebody can help me out.

Thanks in advance.

Lans

Hi,

the easy way, E19 =E1+Sum(B1:B19)

also for column D, D~ = Sum(B1:B~)
which is safer that using D18+B19 in case anyone Inserts a Row,

hth
---