hat
Pou yon lis done ki gen ladan nimewo negatif ak pozitif, ou ka bezwen sòm total valè absoli valè sa yo. Pou egzanp, lis la gen nimewo 7, 8, -10, 5, -25, pou adisyone valè yo absoli, rezilta a yo ta dwe 55 olye pou yo -15. Avèk la Sòm valè absoli sèvis piblik nan Kutools pou Excel, ou ka fasilman sòm total tout valè absoli san yo pa itilize fòmil.
eng
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.