sum absolute values of a column of numbers in Excel

M

MRolko

In Excel, how do I total the absolute value of a column of numbers without
invoking 'abs' function individually on each cell in the range? (e.g.
abs(a1)+abs(a2)+abs(a3)...)
 
R

Ron Coderre

Try this method:

=SUM(ABS(A1:A10))

Note: Commit that array formula by holding down the [Ctrl] and [Shift] keys
when you press [Enter].

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top