You can sum a series of numbers in Excel manually or automatically ... AutoSum works best when you have a column or row of numbers you want to add. 1. Click the cell under a column of numbers ...

It is optional. Array: An array or array formula, or a reference to a range of cells for which you want the number of columns. It is required. Launch Microsoft Excel. Type into the cell A1 ...

Where <prefix> is the prefix to be added and <cell number of first cell> is the location of the first cell in the column to which to add the prefix. Eg. We are creating the list in column C.