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
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