Quantunet.com

My Account

Joins Us
Excel QuickSkills
Using The SUM() Function Knowledgebase  

The SUM() fucntion returns sum total of a range of values.

  • The syntax for the function is SUM (number 1 , number 2, ....number n).

The arguments for the function "number 1, number 2.." can be a series of up to 255 values, a referenced range of cells, an array or a named range. In addition the function can accepts logical values when typed in direclty.

The SUM function is a measure of the total value a range of data points. It sums each of the given arguments and returns a cumulative total. For example: SUM(3,8,4,6,2,5,7) = 33.


How to use the SUM() function:

  • Click on the relevant cell.
  • Type "=SUM(",
  • Enter the reference coordinate of the first cell at the top of the list, "B3".
  • Enter a colon.
  • Enter the cell reference for the last cell in the list "B9".
  • Type " ) " then press the "Enter" key.


 



Note: Referenced cells or array elements that are empty, contain text or logical values are ignored. However cells with a value of zero are included in the calculation of the SUM.



© 2007 Quantunet LLC All Rights Reserved | Intellectual Property | Terms of Use | Privacy
Home | About Quantunet | FAQ's | Contact Us