How to sum income statements from multiple worksheets?

[jesterea]

Hello All,

I am trying to build a model that will contain a "baseline" income statement on one worksheet and several "incramental" income statements for different investment scenarios on other worksheets (structured the same way). I am trying to find the best way to set it up such that I can easily pick and choose which of the investment scenarios will be added to the baseline. For instance, if I select investment scenarios A, B, and C, then the corresponding cells in the worksheets for those scenarios will be added to the baseline income statement. The only way I can think to do so would be several nested SUMIF statements keying off of some fields that I can adjust to indicate whether different scenarios should be "in" or "out". Does anyone know a better solution?



Thanks!

[royUK]

See the Summary sheet example

http://excel-it.com/workbook_downloads.htm

[jesterea]

Thank you Roy, that was very helpful. I'm wondering if there is any way to have a "control panel" of sorts that lists all the different scenarios (tabs) and whether or not they are currently included in the summary calculations. Ideally, I would be able alter whether or not they are included by changing what is shown on the control panel, but alternatively I could continue to control what is being included based on where the tab is positioned, and somehow derive how that tab/scenario should be classified on the control panel based on its position (whether it is between the "top" and "bottom" tabs in the example you referenced. My issue is, after giving it some thought, I haven't been able to get either of these two methods to work. Do you have any thoughts on how I may able to accomplish either approach?

Thanks,

Eric