Using Excel for Iteration Formula

If you want to write a formula for figuring the sum of one set of cells, and then subtracting the sum of another set of cells you could use the following formula. =(SUM(B2:B10))-(SUM(C2:C10)) Excel also allows you to use date from another worksheet of your workbook. To pull data from another worksheet into a formula, identify it in the formula ... ................
................