Excel Auto Sums and Custom Number Format
An Excel tutorial by Peter Kalmstrom In the demo below Peter Kalmstrom gives two Excep tips. He shows four ways to make Excel calculate sums, and he also explains how to add a custom number format to cells.
The possibility to tell Excel to calculate is a crucial feature and the most important reason to use it. In other demos Peter Kalmstrom has shown how to create formulas for plus and minus and how to make Excel mulitpy and divide.
These are the auto sum methods shown in the demo:
To define a custom number format, Peter opens the dialog box launcher of the Number ribbon group and enters a code with hash marks (=display if a value), zero (= numbers should always be displayed) and the value "miles" he wants to add.
- Write in cell coordinates with a plus sign between: =A1+A2+A3
- Write in the first and last cell coordinate: =SUM(A1:A3)
- Press the AutoSum button and accept or reject the suggestion
- Select the cells you want to summarize and press the AutoSum button
Peter uses Excel 2013 for his demo, but the Excel sum calculation and custom number formats are the same for earlier versions of Excel.