Excel Auto Sums and Custom Number Format
An Excel tutorial by Peter Kalmstrom
the demo below Peter Kalmstrom gives two Excel 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:
- 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