You are here: Other Information > Cell Functions > Mathematical and Financial Functions > 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.

Notes

If the argument is used then a constant must be specified.
If the cells are alphanumeric, the TOTAL function returns zero as the value.

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.