TOTAL() adds a series of numbers and returns the total.
Use of variable arrays as a parameter is supported for this function. This means that a list of numeric values can be provided using a single variable array. For more information see Variable Arrays.
TOTAL(N1, N2 <,N3 ...>)
The sum of N1, N2, etc. is returned. If a variable array is used as one of the parameters, all values in contained in the variable array are totalled in conjunction with any other listed parameters.
If the number of decimals in a set of numbers is different, TOTAL() adjusts the result to the greater number of decimals.
If a variable array is used as one of the parameters, all values in contained in the variable array are totalled in conjunction with any other listed parameters.
TOTAL(1.5,2,.75,2.0) = 6.25