Using this leaflet
Suppose you have a sample of three data, 10.4, 11.2 and 16.4, that you have entered into cells A2:A4 on a worksheet. In Excel a function, e.g. SUM, can be applied to these data in one of four ways:
| =SUM(10.4, 11.2, 16.4) | |
| =SUM(A2, A3, A4) | |
| =SUM(A2:A4) | |
| =SUM(x) where x is the name attached to range A2:A4. |
In this leaflet, for simplicity, we have chosen to refer to named ranges. To name a range, simply highlight the range of cells, click in the Name Box on the far left of the Formula Bar, type in the required name, e.g. x, then press Enter. In Excel 2007 names can be managed via Formulas > Name Manager.
If you prefer not to use names then in what follows simply replace the name of the range, e.g. x, by the range address, e.g. A2:A4.