Brother WP330MDS - Manual (Page 208)

2. Functions Using Multiple Arguments
@AVG
Gives the average value of the arguments. The sum of the arguments is
calculated, then that sum is divided by the total number of arguments.
@AVG(1,2,3,4) gives {1+2+3+4)/4 = 2.5
@AVG(175) gives 175/1 = 175
©COUNT
Gives the number of non-blank cells. This function is an exception to the
general rules in that: 1) the arguments MUST be cell addresses, and 2) the
cell referred to may contain alphanumeric or numeric data.
@COUNT(A1,A2,A3,A4) gives 3 if A1 contains 5 (numeric), A2 contains
your name (alphanumeric), A3 contains ERROR (this is not a blank cell),
and A4 is empty.
©MAX
Gives the greatest argument (maximum). Remember that a positive
argument is always greater than a negative one.
@MAX(1,234) gives 234
@MAX(1,-99999) gives 1
©MIN
Gives the smallest argument (minimum). Remember that a negative
argument is always smaller than a positive one.
©MIN(1,234) gives 1
@ MIN(-1,99999) gives -1
©SUM
Gives the sum of the arguments. This function is very useful in shortening
long sums when the arguments belong to a range.
@SUM( 1,2,3,4,5) gives 15
@SUM(A1 ,A2,A3,B1 ,B2,B3) is equivalent to @SUM(A1 ..B3)
©TSUM
Gives the total sum of a range of cells, and also the sum of each row and
column of tho range if they contain data. This function is an exception to the
general rules in that: 1) the argument MUST be a range, and 2) results are
displayed not only in the selected cell (total sum), but also in the column to
the right and in the row below the range. You must therefore be sure that the
column to the right and the row below the range is empty. See below for an
example.
198