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
Last edited by dargonaro; 04-23-2017 at 05:01 PM. Reason: reformulation of wording and attachment for clarification
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.
Teach me Excel VBA
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.
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:Let us know if you have any questions.Formula:
Please Login or Register to view this content.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks