» 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:
- Windows XP All-in-One Desk Reference For Dummies
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Analysis of Financial Statements
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Wall Street Journal Guide to Understanding Money and Investing
No comments have been submitted.
