Home

Excel - simple subtraction -

%3CLINGO-SUB%20id%3D%22lingo-sub-837278%22%20slang%3D%22en-US%22%3EExcel%20-%20simple%20subtraction%20-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-837278%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20basically%20new%20to%20Excel%2C%20so%20bare%20with%20me.%20%26nbsp%3BSUM%20totals%20work%20fine.%20%26nbsp%3BSubtractions%20are%20not%20working.%3C%2FP%3E%3CP%3EAt%20top%20of%20C4%20I%20have%20the%20total%20quantity%20of%20200.%20%26nbsp%3Bperiodically%20a%20%26nbsp%3Bnumber%20should%20be%20subtracted%20so%20I%20have%20a%20TOTAL%20at%20bottom%20of%20column%20(say%20C25)%20that%20shows%20a%20balance%20of%2087%20because%20of%20the%20numbers%20I%20am%20inputting%20should%20be%20subtracting%20not%20adding.%3C%2FP%3E%3CP%3EJust%20need%20this%20subtraction%20to%20work%20for%20a%20single%2C%20simple%20column%2C%20not%20the%20whole%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETaking%20a%20class%20real%20soon%20-%20but%20need%20to%20get%20this%20simple%20formula%20working%20asap.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-837278%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-837328%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20simple%20subtraction%20-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-837328%22%20slang%3D%22en-US%22%3EAre%20the%20numbers%20in%20the%20column%20that%20need%20to%20be%20subtracted%20negative%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-837403%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20simple%20subtraction%20-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-837403%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403487%22%20target%3D%22_blank%22%3E%40Tim18283848585%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20not%20make%20them%20negative%2C%20but%20yes....they%20are%20all%20supposed%20to%20be%20subtracted%20from%20the%20beginning%20number%20of%20200.%3C%2FP%3E%3CP%3Etotal%20showing%20on%20line%20C25%20should%20reflect%2087%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
MzWilli1223
New Contributor

I am basically new to Excel, so bare with me.  SUM totals work fine.  Subtractions are not working.

At top of C4 I have the total quantity of 200.  periodically a  number should be subtracted so I have a TOTAL at bottom of column (say C25) that shows a balance of 87 because of the numbers I am inputting should be subtracting not adding.

Just need this subtraction to work for a single, simple column, not the whole sheet.

 

Taking a class real soon - but need to get this simple formula working asap.

2 Replies
Highlighted
Are the numbers in the column that need to be subtracted negative?
Highlighted

@Tim18283848585 

I did not make them negative, but yes....they are all supposed to be subtracted from the beginning number of 200.

total showing on line C25 should reflect 87

Related Conversations
rusty on ms excel formulas, please help...
saj1011 in Excel on
0 Replies
Help with Formula
Machala Sentance in Excel on
1 Replies
problems creating a diagram in excel
Jagob in Excel on
1 Replies
Generate Invoice Pricing - Multiple Criteria
TarrahLA in Excel on
1 Replies
Convert text in a cell to number
kaibisnes in Excel on
2 Replies
Userform - Submit button not working
Mr_Buttons in Excel on
3 Replies