» 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:
- Marketing Plans
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Windows XP All-in-One Desk Reference For Dummies
- Marketing Management
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
No comments have been submitted.
