We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Excel help!
piggybankrupt
Posts: 181 Forumite
in Techie Stuff
Trying to do my own spreadsheets for budgeting but never been taught formally so making it up as I go along but I'm stumped!
Is there a way say B column & J column added together give total K column how do I get K to work out number in K row above ( ie previous Total +B +J = new total in K
Help!
Is there a way say B column & J column added together give total K column how do I get K to work out number in K row above ( ie previous Total +B +J = new total in K
Help!
Start by doing what's necessary, then what's possible, and suddenly you are doing the impossible.
0
Comments
-
I'm lookin to format the whole column K to hold total then add the next line B & J to make new total in KStart by doing what's necessary, then what's possible, and suddenly you are doing the impossible.0
-
eg in K2, you could have =K1+B2+J2. You then drag the formula down through the whole of column K and it will automatically adjust it for the next rows values.0
-
Thank you! Knew I could rely on this place!Start by doing what's necessary, then what's possible, and suddenly you are doing the impossible.0
-
What if I want M23 as my shortfall so M column needs to be M23 minus total in J but J will change on each row. When I try & copy formula it keeps doing M24 or M25 minus total in J but I want it to always be M23 minus total in J for that row. Hope that makes sense?Start by doing what's necessary, then what's possible, and suddenly you are doing the impossible.0
-
So I can see how my shortfall is going down!Start by doing what's necessary, then what's possible, and suddenly you are doing the impossible.0
-
enter it as $m$23
The $ fixes both positions so that they don't change0 -
formula in M24 should be =M$23-J24. The M$23 part when copied into other column M remains as M$23, but J24 will change to J25 J26 for M25, M26..... If you want to keep column fixed use $M23, if both row and column are to be kept fixed use $M$23piggybankrupt wrote: »What if I want M23 as my shortfall so M column needs to be M23 minus total in J but J will change on each row. When I try & copy formula it keeps doing M24 or M25 minus total in J but I want it to always be M23 minus total in J for that row. Hope that makes sense?0 -
Thanks so much that has worked perfectly! xStart by doing what's necessary, then what's possible, and suddenly you are doing the impossible.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.1K Reduce Debt & Boost Income
- 455K Spending & Discounts
- 246.5K Work, Benefits & Business
- 602.8K Mortgages, Homes & Bills
- 178K Life & Family
- 260.5K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards