Intersecting names

Excel has a special operator, called the intersection operator, that comes into play when you're dealing with ranges. This operator is a space character. Using names with the intersection operator makes it very easy to create meaningful formulas. For this example, refer to Figure 3-2. If you enter the following formula into a cell:

= Qtr2 South the result is 440 — the intersection of the Qtr2 range and the South range. To get the total for the West region, you can use this formula:

=SUM(West)

0 0

Post a comment