AVERAGE function

The Klipfolio AVERAGE function calculates the mean of all non-blank values.

The syntax for the AVERAGE function is:

AVERAGE( data )

AVERAGE example

Let's look at an AVERAGE function example.

 

A

B

1 Apples 10
2 Oranges 12
3 Pears  
4 Peaches 15
5 Bananas 5

The following example is based on the above text from an Excel spreadsheet:

AVERAGE( B:B )

-> [10.5]

Note: In the Properties panel, Decimal Places is set to .#(1).

Related links: