First, specify the ranges. Type or select a worksheet range that contains data you want to summarize, and then click Add. ...

First, specify the ranges. Type or select a worksheet range that contains data you want to summarize, and then click Add. Repeat for each range you want to include.

 You can select each range directly on your worksheet. If you need to move the dialog box out of your way temporarily, click Collapse Dialog {bmp 364}.

 Next, click the number of page fields you want.

 Last, create the item labels that identify the pages you want each page field to display. Select a data range in the All Ranges box, and type or select an item label for the range in each of the available Field boxes. Repeat for each range.