Equivalent to clicking the Scenarios command on the Tools menu and then clicking 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.
|
|
|
|
|
|
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.
Return to index