Combo Box Summary with Dependent List

[bindassladka]

Hi,

I have Region and Branches under dependant combo box.

In Summary, have achived the result of model wise and region wise, but not able to get the information when i select the perticuler branch.

Example:- Under Region tab, there are 5 Region, North, East, South, West, Online and Complete India and under each region there are branches.
What my requirement is: when i select any region, total sum should appear of that perticular region. But when i choose to have an overview of the branch, total sum of material also appear in same formula.

Under Single Formula, Total Sum of Region and Brach should be appear.

Hope your expertiese can give a solution of my problem.

 

[vletm]

bindassladka​

Could You get Your expected results Total Sum of Region and Brach from below output without any formula?

 

[bindassladka]

Hi,

Actually, i dont want to use pivot table, since have to compile/consolidated on month on month basis/product wise.

 

[vletm]

bindassladka​

since have to compile/consolidated on month on month basis/product wise.
That would be interesting have to without date-data.

 

[bindassladka]

Please help me on this..

actually am not able to get the desire information in nested formula, though if have to choose branch, than results are there by using sumif and index, problem here is, both the results (First Region then Branch) should appear under one coloum.

 

[vletm]

bindassladka​

Could You show Your expected results visually?

 

[bindassladka]

Here is the result. I want these two nested formulas in one.

 

[vletm]

bindassladka​

Okay ... but
... I've some minor challenges ...
Your sample data misses still Your named date (for month on month basis/product wise) and Category.
Region North has data only with LUC branch.
Your expected results Models are missing too.

Do You really expect to get 17 results with one formula?
Those Your sample three sheets should have something else to use those with any formulas.