SUM Function Dictionary

Function Dictionary	Function Examples	Function Categories

SUM
		Horizontal
		100	200	300	600	=SUM(C4:E4)
		Vertical
		100
		200
		300
		600	=SUM(C7:C9)
		Single Cells
		100		300	600	=SUM(C13,D14,E13)
			200
		Multiple Ranges
		100		400
		200		500
		3000		600
				4800	=SUM(C17:C19,E17:E19)
		Functions
		100		400
		200		500
		300		600
				800	=SUM(AVERAGE(C23:C25),MAX(E23:E25))
	What Does It Do ?
	This function creates a total from a list of numbers.
	It can be used either horizontally or vertically.
	The numbers can be in single cells, ranges are from other functions.
	Syntax
	=SUM(Range1,Range2,Range3... through to Range30).
	Formatting
	No special formatting is needed.
	Note
	Many people use the =SUM() function incorrectly.
	This example shows how the SUM has been combined with plus + symbols.
	The formula is actually doing more work than needed.
	It should have been entered as either =C48+C49+C50 or =SUM(C48:C50).
		100
		200
		300
		600	=SUM(C48+C49+C50)			Wrong!
			=SUM(C48:C50)			Correct
			=C48+C49+C50			Correct