Math Functions
Mayakrishnan Ramar avatar
Written by Mayakrishnan Ramar
Updated over a week ago

 

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.

Did this answer your question?