|  

» Summing Values at the Intersection of Two or more Ranges

CATEGORY - Summing VERSION - All Microsoft Excel Versions
To sum figures at the intersection of two or more ranges:

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.
Screenshot // Summing Values at the Intersection of Two or more Ranges
Summing Values at the Intersection of Two or more Ranges


Rate This Tip
12 34 5
Rating: 2.25     Views: 16245
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments