Hey all,
I've been having some help here with my spreadsheet (not to good with Excel) and once again have come across another problem I can't work out or find a solution for.
In A1 there is a number and I want this number to go down by whatever number is entered into cells C3 - C20
Just to clarify, if I add 5 to C3 (making it 20), A1 will change to 495, if I then add 20 to C13, A1 will change to 475 etc.
Could someone explain how this is done please?
Thank you
Last edited by toxictoad; 01-10-2012 at 01:02 PM.
You can't enter a number into a cell, then consecutively subtract from it with formulas (only with VBA)
To avoid VBA, enter the 500 in another cell (except within column C), say B1 (you can hide it by colouring the font to match the background).
Then in A1 enter formula: =B1-SUM(C:C)
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Use this formula in A1 -=500-SUM(C3:C20)
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Re: Subtracting from multiple cells
Thank youwhere would I be with out your help? Forever getting nowhere!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks