» Summing the Absolute Values of All Numbers in a Range
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Summing the absolute values of all the numbers in List1 (column A).
Solution:
Use the SUM and ABS functions as shown in the following Array formula:
{=SUM(ABS(A2:A8))}
Book Store:
Recommended Books:
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Analyzing Markets, Products, and Marketing Plans
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Mastering Excel 2000 (for beginner)
- Absolute Beginner's Guide to Microsoft Excel 2002
No comments have been submitted.
