Sum Indirect??

[Schubby10]

Hey,

So I have many P+L's and looking to create one roll up depending on which P+L's I choose. Wondering how I would create this?

I have each P+L on a separate tab The summary would be where I select whatever accounts I want.

Thank you for the help,

 

[Special-K99]

If the layouts are the same and there is no missing data you could use

(Google) Excel 3D Reference / 3D SUM