For example if I sum 2 cells where each value is 1, I get a result of 2.
Usually when you have a formula in Excel 2003, if any of the data changes the result of the formula automatically changes.
Somehow my documents have lost this ability and I now must click on the cell, click in the formula line and hit enter in order for it to actually update with the new input data. Usually when you have a formula in Excel 2003, if any of the data changes the result of the formula automatically changes.
To become an Excel power user, you need to know how to use array formulas, which can perform calculations that you can't do by using non-array formulas.
The following article is based on a series of Excel Power User columns written by Colin Wilcox and adapted from chapters 14 and 15 of Excel 2002 Formulas, a book written by John Walkenbach, an Excel MVP.
You can use formulas in Microsoft Excel 2010 to perform calculations based upon the values in your spreadsheet.