SOLVED

need excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2550615%22%20slang%3D%22en-US%22%3Eneed%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2550615%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20with%20writing%20a%20formula.%20What%20I%20need%20is%20an%20auto%20sum%20formula%20that%20will%20total%20a%20line%20of%20cells%20with%20numbers%20that%20are%20both%20positive%20and%20negative%20numbers%2C%20but%20not%20adding%20and%20subtracting%2C%20only%20totaling%20the%20numbers.%3C%2FP%3E%3CP%3EExample%2C%26nbsp%3B%20%26nbsp%3B%205%2C%205%2C%20-10%2C%205.%26nbsp%3B%20%26nbsp%3Bthe%20answer%20would%20be%2025.%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2550615%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2550653%22%20slang%3D%22en-US%22%3ERe%3A%20need%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2550653%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1103972%22%20target%3D%22_blank%22%3E%40kcbikeswim%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSUM(ABS(A1%3AA4))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2551058%22%20slang%3D%22en-US%22%3ERe%3A%20need%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2551058%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1103972%22%20target%3D%22_blank%22%3E%40kcbikeswim%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20everyone's%20permission%2C%20I%20would%20like%20to%20add%20this%20example%20to%20Mr.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3EDetlef%20Lewin%3C%2FA%3E%3C%2FP%3E%3CDIV%20class%3D%22user-login%22%3Every%20good%20suggestion.%3C%2FDIV%3E%3CDIV%20class%3D%22user-login%22%3EEnclosed%20in%20the%20file.%3C%2FDIV%3E%3CDIV%20class%3D%22user-login%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22user-login%22%3EThx%3C%2FDIV%3E%3CDIV%20class%3D%22user-login%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2553047%22%20slang%3D%22en-US%22%3ERe%3A%20need%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2553047%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much.%20Really%20appreciate%20the%20help%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2553211%22%20slang%3D%22en-US%22%3ERe%3A%20need%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2553211%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1103972%22%20target%3D%22_blank%22%3E%40kcbikeswim%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20me%20the%20formula%20is%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D%20SUM(ABS(Value%E2%82%81))%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Ebut%2C%20for%20anyone%20stuck%20with%20legacy%20versions%20of%20Excel%2C%20it%20is%20also%20possible%20to%20use%20a%20defined%20name%20for%20the%20array%20calculation.%26nbsp%3B%20The%20formula%20is%20then%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D%20SUM(Absolut)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%5Bwithout%20CSE%5D%20where%20'%3CSTRONG%3EAbsolut%3C%2FSTRONG%3E'%20is%20defined%20to%20be%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D%26nbsp%3BABS(Value%E2%82%81)%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I need help with writing a formula. What I need is an auto sum formula that will total a line of cells with numbers that are both positive and negative numbers, but not adding and subtracting, only totaling the numbers.

Example,    5, 5, -10, 5.   the answer would be 25.

Thanks 

4 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@kcbikeswim 

=SUM(ABS(A1:A4))

@kcbikeswim 

With everyone's permission, I would like to add this example to Mr.Detlef Lewin

Thank you so much. Really appreciate the help

@kcbikeswim 

For me the formula is 

= SUM(ABS(Value₁))

but, for anyone stuck with legacy versions of Excel, it is also possible to use a defined name for the array calculation.  The formula is then

= SUM(Absolut)

[without CSE] where 'Absolut' is defined to be

= ABS(Value₁)