» Summing Values at the Intersection of Two or more Ranges
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
Leave a space between the argument ranges in the SUM formula.
The SUM formula in cell F3 totals the figures in range B3:C5.
The SUM formula in cell F5 totals the figures at the intersection of columns B:C and row 5:5.

Book Store:
Recommended Books:
- Accounting for Dummies
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- The Fall of Advertising and the Rise of PR
- Advanced modelling in finance using Excel and VBA
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Financial Risk Manager Handbook, Second Edition
No comments have been submitted.

