Question: In the Annual Volume cell B 3 , create a formula that adds the Sales Volume for that model number from the 4 previously created
In the Annual Volume cell B create a formula that adds the Sales Volume for that model number from the previously created Q Actual, Q Q & Q worksheets. Make sure that the values generated by this formula in this cell will automatically update if any of the input values are changed on any of the individual quarterly sheets at a later time. If you do this right, by changing a volume on the Q page then your awesome formula on this summary page will recognize the fact that you changed that cell and automatically recalculate your summary value! Copy this formula down for all of the models. The demonstration of how to do this is on the Module Level Part video.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
