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 B3, create a formula that adds the Sales Volume for that model number from the 4 previously created Q1 Actual, Q2, Q3 & Q4 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 4 individual quarterly sheets at a later time. If you do this right, by changing a volume on the Q1 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 1 Level 3 Part 2 video.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!