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.
Last edited by Pontorson; 08-08-2010 at 06:29 PM.
what formula?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
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
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
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.
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
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
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.
change e6 to
=IF(C6="M","£23.50",IF(C6="F","£30.00",""))
then f6 to =IF(E6="","",SUM(F5,-E6))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
That is fantastic, Martin! Thank you so much for sparing the time and trouble to sort it out for me. Much appreciated.
P.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks