For a list of data which contains both negative and positive numbers, you may need to sum the absolute values of these values. For example, the list contains numbers 7, 8, -10, 5, -25, for summing the absolute values, the result should be 55 instead of -15. With the Sum absolute values utility of Kutools for Excel, you can easily sum all absolute values without using formulas.
[ Ссылка ]
