Thanks, Yacbo!
I still get stuck. Kassie has been a great help, though. I still have
problems in other columns with them being filled in all the way down with
'incorrect' figures until I make an entry. When I make an entry it corrects
the figure in the adjacent cell to which it refers but the rest, all the way
down should not be there. It drives me mad. It doesn't happen with the
Formula Kassie gave me, though (=IF(G9="","",H10+G9). Can I call on you guys
again or will I drive you all mad?
Gatsby.

"Yacbo" wrote:

Sorry I missed all the fun, but it sounds like you are cruising now!
--
Y


"Gatsby" wrote:

G H
450.00 450.00 (G9)
425.00 875.00 (G10+H9)
430.00 1320.00 (G11+H10)
422.00 1742.00 (G12+H11)
1742.00
1742.00
I have to type in the formula in H each time I make an entry in G in order
to get H to complete. If I drag the auto complete down it fills in the last
entry all down the column, which I don't want to happen. Why doesn't excel
recognise what I'm at and just fill in column H for me? Although the above
example only shows four entries, it's the same after seven. The Autocomplete
box is ticked.
Help anyone? - Gatsby