» Summing the Absolute Values of All Numbers in a Range
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Problem: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:
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Retire Young, Retire Rich
- Positioning: The Battle for Your Mind
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Microsoft Excel 2002 Simply Visual
No comments have been submitted.
