SCENARIO.SUMMARY

Macro Sheets Only

Equivalent to choosing the Scenarios command from the Tools menu and then choosing the Summary button. Generates a table summarizing the results of all the scenarios for the model on your worksheet.

Syntax

SCENARIO.SUMMARY(result_ref, report_type)
SCENARIO.SUMMARY?(result_ref, report_type)

Result_ref is a reference to the result cells you want to include in the summary report. Normally, result_ref refers to one or more cells containing the formulas that depend on the changing cell values for your model—that is, the cells that show the results of a particular scenario.

• If result_ref is omitted, no result cells are included in the report.
• If result_ref contains nonadjacent references, you must separate the reference areas by commas and enclose result_ref in an extra set of parentheses.

Report_type is a number specifying the type of report desired.

Report_type Type of Report

1 or omitted A scenario summary report (Microsoft Excel 4.0)

2 A scenario PivotTable. Requires result_ref.

Remarks

• SCENARIO.SUMMARY generates a summary table of the changing cell and result cell values for each scenario.
• The table is generated on a new sheet in the current workbook. The sheet becomes active after SCENARIO.SUMMARY runs.

Related Functions

List of Command-Equivalent Functions