Home >Tips >Excel auto sums and custom number format kalmstrom.com site map icon Site map  

Excel Auto Sums and Custom Number Format

An Excel tutorial by Peter Kalmstrom

Excel iconIn 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:
  • Write in cell coordinates with a plus sign between: =A1+A2+A3

  • Write in the first and last cell coordinate: =SUM(A1:A3)

  • Excel AutoSum buttonPress the AutoSum button and accept or reject the suggestion

  • Select the cells you want to summarize and press the AutoSum button

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.
 
Excel custom number format

Peter uses Excel 2013 for his demo, but the Excel sum calculation and custom number formats are the same for earlier versions of Excel.