#### 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.