» 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:
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Getting to Yes: Negotiating Agreement Without Giving In
- The Intelligent Investor: The Classic Bestseller on Value Investing
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
