• Mathematical and Financial Functions
  • Mathematical and Financial Functions
  • ABS function
  • AVERAGE function
  • CGROUP function
  • CGROUPT function
  • COLCOUNT function
  • EXP function
  • FV function
  • LOG function
  • MAX function
  • MEDIAN function
  • MIN function
  • MKDEC function
  • MKINT function
  • MOD function
  • POS function
  • PV function
  • R function
  • RATIO function
  • RC function
  • RCNV function
  • RCR function
  • RCTOTAL function
  • ROUND function
  • ROWCOUNT function
  • RR function
  • RRTOTAL function
  • STDDEV function
  • SUM function
  • TOTAL function

TOTAL Function

The TOTAL function calculates the sum of a range of cell values. An optional constant may be added to sum all cells in a specific increment. If no constant is supplied, an increment of one is assumed.

Syntax

TOTAL(first cell..last cell,<step>,<argument>)

The first and last cells denote the range to be totalled.

The step specifies if any cells should not be included. If no value is entered, the default step is 1 (include all).

The argument is optional and controls what value types are included. If no argument is specified, the function sums the contents of all cells in the range.

Argument	Result
0	The function returns a count of all cells in the range.
1	The function returns a count of cells in the range that have a non-zero value.
2	The function returns the sum of all cells in the range with positive values.
3	The function returns the sum of all cells in the range with negative values.

A cell with a zero value is a cell that is empty or that contains a blank.

Example 1

TOTAL(c1..c9)

Returns the sum of all cells numbered c1 to c9.

Example 2

TOTAL(c2..c10,2)

Returns the sum of cells numbered c2, c4, c6, c8, c10.

Example 3

TOTAL(c2..c10,1,1)

Returns the count of all non-zero value cells in the range c2 to c10.

A detailed example is available.

Related Topics

• Mathematical and Financial Functions