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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies