Excel Auto Sums and Custom Number Format
An Excel tutorial by Peter Kalmstrom
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
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
- Write in cell coordinates with a plus sign between: =A1+A2+A3
- Write in the first and last cell coordinate: =SUM(A1:A3)
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.