summary excel table for output results based on multiple choice input data

[dargonaro]

Hi experts!
I would like to create a summary excel table with two entries (year xx and output xx), that summarises the output computed by a formula linked to a reference cell.
Please see excel sheet in attachment for clarification.
Thank you all
Dargo

[ImranBhatti]

Output!C3 changes and Summary Table sheet cells will definitely change,coz you have referenced them.When a value of reference cell changes ,your formula results also change.

[dargonaro]

Thanks for your quick answer.
I reformulated my problem in a more direct way.
I still believe that a summary table could be created with data generated from a reference cell.

[JeteMc]

If I understand correctly the following formula may be pasted into cell D19 and dragged across: =PRODUCT(D6:D8)
You may also want to consider making the following change to the formula in D12 to make it easier to deal with once your project is extended to year 4 and beyond:

=INDEX(D6:G6,MATCH(D11,D5:G5,0))*INDEX(D7:G7,MATCH(D11,D5:G5,0))*INDEX(D8:G8,MATCH(D11,D5:G5,0))

Let us know if you have any questions.

[dargonaro]

Thank you for the answer.It is not yet what i was expected. The reason is obviously the formulation of my question.
I therefore reformulated the problem in a more appropriate way in the revised attachment.
I hope this will help.
Thank you