Set a range as "Absolute" values
I use a same range to enter minus() values and also plus(+) values to differentiate between negative and positive.
However i need to SUM this range as a whole (i.e. a credit/debit column) = this is difficult to do as sum function will +/ the values
If i can set that column or range as an "Absolute" range, then SUM and other functions can honour the abs() value if need be
3 comments

Ricardo Suárez commented
Also, you can use the SumProduct function instead of using arrayenter (ctrlshiftenter). You just have to write your formula this way: =SUMPRODUCT(ABS(A1:A10)) and voilá.

Bill Young commented
You can do this using array formulas. =SUM(ABS(A1:A10)), then instead of "enter", you do "ctrlshiftenter". This will make the formula have curly brackets around the end: {=SUM(ABS(A1:A10))}. You don't type those brackets, the ctrlshiftenter puts them in for you.
Still it would be nice to have this feature available in a formula, maybe =SUMABS() for people not trained in the complex world of array formulas.
I use this concept to detect premium errors. If I get a multilocation insurance rating for a business, it is usually on dozens or hundreds of pages of paper. No customer wants to dig through all that paper. I like making the rating on a single spreadsheet that prints out on far fewer pages. Then at the end of each location, I use the formula "=Actual premium  calculated premium" (to show the difference between my spreadsheet calculated premium and the premium produced by the insurance company. In some ratings, there are factors that change depending on the entire premium size, so as you add locations, it changes the calculations of all other locations. So in some instances I will be $1 too high, and in others $1 too low. Adding together the absolute value of these differences will tell me the total amount I am off. When this becomes zero, I'm spoton.

Victor Wright commented
i.e. = SUM( ABS( A1:A10 ) )