» 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:
- The Interpretation of Financial Statements
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- The Guide to Understanding Financial Statements
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Special Edition Using Microsoft Access 2002
- Financial Modeling - 2nd Edition
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
