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)...)
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)...)
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
"MRolko" wrote:
> 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)...)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks