Using Excel's ABS Function with SUM AVERAGE MAX & MIN

The scenario: I have a list of test results, some are negative numbers and some are positive. I want to do some calculations on the results, like add them all up or find the largest number. The thing is I want to treat all the numbers as positive. The ABS function removes the negative sign but it can't deal with ranges like SUM or AVERAGE can. This is where we need an array formula, using CTRL SHIFT ENTER to confirm our formula.
------------------------

[vachikarmenian]

Extremely helpful and to the point.


Thank you VERY much Chester

[gopalakrishnarao]

Simple and powerful technique. Thanks for the upload.

[mohamedelhaj]

Anyway to return the max value with its sign (-100) in this case?

[sarawoodmansee]

How do I figure a sum and range 3d graph equation x- range y probability....x9y18

[aneesrahman]

If some values is nil or some text in between it doesn't work