Microsoft Office Tutorials and References
In Depth Information
Using the Name Menu to Create Names
FIGURE 4.11 Selecting a Range Using the Name Box
FIGURE 4.12 Using the Formula
¼
SUM(Sales)
FIGURE 4.13 Selecting an Intersection of Two Named Ranges
¼
SUM(C2:C8). Now you can simply use the formula
¼
SUM(Sales) resulting in the
sum seen in Figure 4.12.
Try other combinations with the created names. Try
¼
SUM(Cost). Experiment
with
Feb.) This
will result in the intersection of the Cost and Feb: 26. See Figure 4.13 for the
intersection.
¼
SUM(Cost, Profit). Try something else:
¼
Cost Feb (
¼
Cost
þ
space
þ
Search JabSto ::




Custom Search