» 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:
- How to Read A Financial Report
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Business Plans For Dummies®
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
No comments have been submitted.
