...
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. |
1. Select C4 on Sheet1.
2. Start to type the formula by entering =(
...