Kassie, that's working! Thanks very much for helping me. I've spent hours
trying to get around it, wondering what was wrong? Have you any idea why 'my
way' doesn't work? Thanks again.
Gatsby

"kassie" wrote:

Change your formula to read =IF(G12="","",H11+G12), and drag all the way
down. This way, H will remain blank until G gets a value. In your scenario,
H12 will show a value, but H13 will remain blank until you enter a value in
G13
--
Hth

Kassie Kasselman


"Gatsby" wrote:

Thanks for answering Gord.
Automatic is ticked and this still is happening. It seems to be only when
I'm doing accumulating that this problem arises. Any other ideas on how to
solve it? I'd appreciate it.
Gatsby

"Gord Dibben" wrote:

ToolsOptionsCalculation.

Set to Automatic.


Gord Dibben MS Excel MVP

On Sat, 6 Jan 2007 18:06:00 -0800, 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