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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies