Sum and subtraction

%3CLINGO-SUB%20id%3D%22lingo-sub-2367133%22%20slang%3D%22en-US%22%3ESum%20and%20subtraction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2367133%22%20slang%3D%22en-US%22%3EI%20need%20help%3CBR%20%2F%3EHow%20do%20i%20substract%20two%20sums%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2367133%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-2367212%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20and%20subtraction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2367212%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1057579%22%20target%3D%22_blank%22%3E%40MikeR1915%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fsum-and-subtraction%2Fm-p%2F2367146%22%20target%3D%22_blank%22%3ESum%20and%20subtraction%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2367576%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20and%20subtraction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2367576%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1057579%22%20target%3D%22_blank%22%3E%40MikeR1915%3C%2FA%3E%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fsubtract-numbers-938b7912-5699-4609-969b-38b23ca00d54%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ESubtract%20numbers%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3ENote%3A%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3BThere%20is%20no%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ESUBTRACT%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bfunction%20in%20Excel.%20Use%20the%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ESUM%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bfunction%20and%20convert%20any%20numbers%20that%20you%20want%20to%20subtract%20to%20their%20negative%20values.%20For%20example%2C%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ESUM(100%2C-32%2C15%2C-6)%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Breturns%2077.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fsum-function-043e1c7d-7726-4e80-8f32-07b23e057f89%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ESUM%20function%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ESUM%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bfunction%20adds%20values.%20You%20can%20add%20individual%20values%2C%20cell%20references%20or%20ranges%20or%20a%20mix%20of%20all%20three.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
I need help
How do i substract two sums?
2 Replies

@MikeR1915    

 

Subtract numbers

Note: There is no SUBTRACT function in Excel. Use the SUM function and convert any numbers that you want to subtract to their negative values. For example, SUM(100,-32,15,-6) returns 77.

 

SUM function

The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.

 

Hope I was able to help you with this info.

 

Nikolino

I know I don't know anything (Socrates)