Microsoft Excel SUM Function Help
EMAGENIT Home page

Call us at:   1.805.498.7162     1.805.558.9277--

Learn about how we can help your company or yourself achieve your Microsoft Excel training or self-study goals Visit our free Microsoft Excel and Microsoft Excel VBA resource center Learn how we can help save your company money with our innovative software solutions Visit out VBA code center for code that can save your company money Learn about our Excel Add-In software that can save your company time and money View our customer list from our 12 years in business Phone numbers, request form and email address Learn about EMAGENIT View our training schedule for Microsoft Excel and Microsoft Excel VBA

 

SUM Function Examples

SUM Function Definition

Adds all the numbers in a range of cells. Capable of adding 30 separate ranges, cells and/or numbers together

Sum Function Syntax

=SUM(number1,[number2], ...,[number30])

[] bracket means argument is optional which means you do not have to fill the slot.

SUM Function Argument Definitions

number1, number2, ...number30:   These are 1 to 30 arguments for which you want the total value or sum. Replace each argument with a number, a cell reference, range reference, cell name, range name, function or formula that generates a number.

SUM Function Tips

  • Numbers, TRUE,  FALSE and text representations of numbers that are typed directly into the SUM function argument list are counted.
  • If using a range, only numbers in that range are counted. Empty cells, TRUE, FALSE or numbers displayed as text in the range are ignored.
  • References (cell or ranges) or formulas that produce error values or text that cannot be translated into numbers will cause an error.