Create Summary table from dynamic values

[abhi900]

Hi,

I have dropdown list of values in sheet1 which Invokes the total number based on the selection from dropdown and a formula under these 2 cells in sheet2.

In essence
sheet1 - from dropdown Value 3 and now in sheet 2
Sheet2 -
cell B44 (formula SubTotalCrash: SUM (a+b+"dropdown value 3"))
cell B45 (formula TotalCrash: SUM (c+d+B44)

I have Value 1 - Value 23 in the dropdown. So sheet 2 B44 cell works on single dropdown value.

I want to create a summary data table in Sheet 1 as:
Values SubTotalCrash TOTAL Crash
1 25 50
2 15 16
-
-
23 145 20

How do i create such datatable ? As I have dependent on the dynamic selection from dropdown in sheet 1 and only then my sheet2 totals populate based on the dropdown value when fed.

CANNOT USE MACRO / VB / PIVOT but ONLY Formula.

[huuthang_bd]

You can use tool 'Data Table'

Capture.PNG

[abhi900]

You can use tool 'Data Table'

Attachment 641120

Hmm can't use any tool or so. Need too be populated by using formulas and so.

[huuthang_bd]

Solving by only formulas is impossible. Why do you use only formulas?

[abhi900]

Has to be a way for sure to use lookups or so..