...
The next step is adding references to the data sheet. This example references the "SUM" formulas on the data sheet. These sums are added to a percent change equation. This will result in a template resembling the following:
Note the formula in the formula bar, "Sheet2" is the data sheet.
Also, the error message is because there currently isn't any data, so Excel is throwing a 'Divide by 0' error. This will not be in the output file because the file will contain data.
Info | ||
---|---|---|
| ||
In this example, the sum rows alternate on the data sheet. If you stretch a formula, you'll have to update the references to skip every other row. |
...