Applying a formula to whole column

[Pontorson]

Hi everyone

I have worked out a formula to return a running total in column B, having typed an item of expenditure in column A.

How do I apply the formula to the (presently unused) cells further down in column B, so it will continue to calculate as more items are entered in A? If I drag the fill handle it copies the total into all the cells, which I want to leave blank until used.

Sorry if this is really pathetic question, but I've hunted through Help and this forum to no avail! Many thanks.

P.

[martindwilson]

what formula?

[royUK]

I wouldn't even consider it. All those formulas will calculate constantly, slowing the workbook's calculation

You should fill in your user profile to say which version of Excel that you are using

[Pontorson]

Martin, it's just =SUM(B14,-A15), where B14 is the last total and A15 is the amount spent.

Roy, sorry - I thought I had - it's 2003.

Looks like it's a no no - thanks for your help!

P.

[martindwilson]

i think roy thought you meant right down to the last row
it is possible to show nothing in a cell until an entry is made in another
post an example

[Pontorson]

Hi Martin

The rules suggested attaching a workbook - so here goes!

The idea is that the cost in column E is subtracted from the running total in column F.

Would be grateful to know how "to show nothing in a cell until an entry is made in another" so that an amount can be put in column I when a new surgery date is entered, for example.

Cheers!


P.

[martindwilson]

change e6 to
=IF(C6="M","£23.50",IF(C6="F","£30.00",""))
then f6 to =IF(E6="","",SUM(F5,-E6))

[Pontorson]

That is fantastic, Martin! Thank you so much for sparing the time and trouble to sort it out for me. Much appreciated.

P.