sum absolute values of a column of numbers in Excel

G

Guest

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)...)
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using sum function with absolute numbers 6
Sum of a range of absolute numbers 4
SUM of ABS values 6
Need Help with "SUM" AND "ABS" in same formula 12
rank the numbers / range of data using 'RANK' and 'ABS' 1
summing an array of cells absolute value 3
Subtotal of Abs of a range? 3
get max or min number 9

Top