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
4 comments

Roy commented
The source basis of the problem is Excel produces arrays as the "interior" functions' outputs to the outer functions and the outer functions often cannot make use of material in array format, or sometimes they could if it were typed in that way, but not when presented as interior function outputs into them(!)...
The interior function's output clearly is the array we can make seen, but with something slightly extra, or missing, so it cannot be interpreted by the function receiving it.
So =SUM(ABS(A1:A4)) yields the #VALUE! error because "ABS(A1:A4)" gives an output of (literally) " {7;15;6;3} " and SUM() cannot handle that when presented with it from evaluating the ABS() function.
BUT if you typed " =SUM({7;15;6;3}) it properly yields "31" as its result, not "#VALUE!".
What we really need is either for Excel to dress that up (it clearly is presenting something slightly different than the above when IT evaluates the ABS() function here and needs to clean that up) or it should give us a function that takes (in this case, but of course ANY function's arrayish output) ABS() (clearly not just the array, but a wee bit more) and cleans it to the typed version before presentment further outwards.
I think I'll add that thought as a separate suggestion since this affect a HUGE number of situations and I have never found a workaround, just rewriting, usually with different functions, of formulas or using the CtrlShiftEnter array approach with its attendant oddities/hassles.
That way this one would be solved (better!) or at least amenable to a fix by wrapping it in an extra function (like we do with TRIM() and so on) without the Excel programmers having to address it ad hoc function by function leading to either "it's too beastly to attempt so too bad dudes" or new issues.

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 ) )