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
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
Are the numbers in the column that need to be subtracted negative?

@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
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
INDEX & MATCH interrupted by Inconsistent Dates
shade206 in Excel on
18 Replies
Need to extract values from named cells (Get and Transform)
JEMagnussen in Excel on
23 Replies