### SUM

The SUM function adds all the numbers that you specify as arguments. Each argument can be a field, a constant, a formula, or the result from another function.

To calculate the sum of several fields, simply insert:

SUM(field1,field2,field3…)

In context this might look like this: For the Total Attendance Field, the formula would look like this: In your form, it will look like this: ### AVERAGE

The AVERAGE function gives the arithmetic mean of a set of numbers.

The syntax is:

AVERAGE(field1,field2,field3…)

Notes:

• You can add a maximum of 255 fields.

• If one of your field has text, logical values, or empty values, those values are ignored. However, if a field has the number 0, that will be used to calculate the average.

• If a field returns an error value, the AVERAGE will also return an error.

• If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the AVERAGEA function.

### AVERAGEA

The AVERAGEA function measures central tendency, which is the location of the center of a group of numbers in a statistical distribution.

The syntax is:

AVERAGEA(value1,value2,…)

Notes:

• You can have the following arguments: numbers; names, arrays, or references that contain numbers; text representations of numbers; or logical values, such as TRUE and FALSE, in a reference.

• Logical values and text representations of numbers that you type directly into the list of arguments are counted.

• Arguments that contain TRUE evaluate as 1; and arguments that contain FALSE evaluate as 0 (zero).

• Array or reference arguments that contain text evaluate as 0 (zero). Empty text (“”) evaluates as 0 (zero).

• If an argument is an array or reference, only values in that array or reference are used. Empty cells and text values in the array or reference are ignored.

• Arguments that are error values or text that cannot be translated into numbers cause errors.

• If you do not want to include logical values and text representations of numbers in a reference as part of the calculation, use the AVERAGE function.

### PRODUCT

The PRODUCT function multiplies all the numbers in a set of arguments.

The syntax is:

PRODUCT(field1,field2,field3…)

Notes:

• If an argument is an array or reference, only numbers in the array or reference are multiplied. You can ignore the empty fields, logical values, and text in the array or reference.

### COUNTA

The COUNTA function counts the number of fields that are not empty in a range.

The syntax is:

COUNTA(value1, [value2], …)

Notes:

• The COUNTA function counts fields containing any type of information, including error values and empty text (“”). For example: If the range contains a formula that returns an empty string, the COUNTA function counts that value.

• The COUNTA function does not count empty fields.

• If you do not need to count logical values, text, or error values (in other words, if you want to count only cells that contain numbers), use the COUNT function.