Step 1 Calculate average total average quarterly sales dynamically, this requires adding up the four sales periods and dividing by 4 Step 2 Use goal seek to determine the sales amount required in the fourth quarter to reach the average total goal mentioned in step 3 Step 3 For scenario A, average total is 1333, Scenario B is 912, Scenario C is 1051 Quarter 1 801 Quarter 2 1250 Quarter 3 956 Quarter 4 Total 912 Hint use sum or autosum function Average Per Quarter Hint use average function or divide by the number of quarters