Excel: Sounds Good Page 1 2 3 4 5 6 7 8 9 10 11 12 13

Create a Reference Cell Read across your spreadsheet: cell D5 is the initial quantity sold. Cell D6 should be whatever we sold on the first day, plus the quantity we are forecasting for each day’s sales increment.   Try it: Create a Reference Cell Select D5 and enter this equation:  =B1 Select D6, and enter this equation:  =D5 +B2   Test your equation: change the Initial number in cell B2 from 100 to 90. What do you see in cell D5 or D6? Now, double click the AutoFill handle to fill down the series.