Tom’s Tutorials For Excel: Summing The Intersection of Two Ranges
Here’s a way to structure a
SUM function for operating on an intersection of rows and columns.
In the picture, there are row and column totals for the entire year’s Income budget. But suppose you only want to look at, say, Quarter 3, and only for, say, certain income streams such as Training, Disk Sales, and Videos. And further suppose you prefer to think of your services in terms of their occupied rows and columns.
The formula in cell N1 is
Notice the construction:
One piece of the intersection is columns H, I, and J.
Another piece is rows 9, 10, and 11.
Those two components are entered as you see, separated by a space.