» 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:
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Word 2002: The Complete Reference
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Marketing Plan: A Handbook with Marketing Plan
- Yes, You Can Time the Market!
- Fish! A Remarkable Way to Boost Morale and Improve Results
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
