Hi everyone I am doing an exercise where I am trying to sum across multiple tabs based on the drop down. Summing part I know how to do w/ INDIRECT i.e. =SUM(INDIRECT("'"&Tabs&"'!"&CELL("address")))
where "Tabs" is defined name range.
the curve ball is that each of those tabs has different weight (not sure weight is the right word, but it's more of the company's controlling interest)
so below is very rough example, we would get $1,264 if we apply the weight
Tab1 $1,000 100%
Tab2 $500 33%
Tab3 $300 33%
but it's not just one number, it's the entire P&L and there are several portfolios (based on the drop down they will look at different tabs), so I am looking for perhaps one formula that can solve this problem.
Many thanks in advance.
where "Tabs" is defined name range.
the curve ball is that each of those tabs has different weight (not sure weight is the right word, but it's more of the company's controlling interest)
so below is very rough example, we would get $1,264 if we apply the weight
Tab1 $1,000 100%
Tab2 $500 33%
Tab3 $300 33%
but it's not just one number, it's the entire P&L and there are several portfolios (based on the drop down they will look at different tabs), so I am looking for perhaps one formula that can solve this problem.
Many thanks in advance.