» Summing the Values of Cells Occurring at the Intersection of Ranges
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Problem: Range A1:B5 contains numbers.
We want a total value of the cells occurring at the intersection of the following ranges:
1. Columns A:B, Row 2:2
2. Column A:A, Row 3:4
3. Columns A:B, Row 1:1 + Columns A:B, Row 5:5
Solution:
Use the SUM function as shown in the following formulas:
1. =SUM(A:B 2:2)
2. =SUM(A:A 3:4)
3. =SUM(A:B 1:1,5:5)
Book Store:
Recommended Books:
- Word 2002: The Complete Reference
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Keys to Reading an Annual Report (Barron's Business Keys)
- Getting to Yes: Negotiating Agreement Without Giving In
No comments have been submitted.
