AVERAGE

=AVERAGE(A1:A5)

=AVERAGE(10,3; 9,1)        

Calculates the average value of values within the list

AVERAGEA

=AVERAGEA(A1:A5)

Calculates the average value of the non-empty cells referenced.AVERAGEA(range) equals SUM(range)/COUNTA(range).

COUNT        

=COUNT(A1:A4)

=COUNT(1; 5; 8)

Returns the number of cells in a given range

COUNTA

=COUNTA(A1:A4)

Counts the number of non-empty cells in a given range.

COUNTBLANK

=COUNTBLANK(A1:E1)

Counts the number of empty cells

MAX

=MAX(A1:D1)        

=MAX(A1; 100; C2)        

Returns the largest argument value.

MIN

=MIN(A1:D1)

=MIN(0; C2)

Returns the smallest argument value

SUM

=SUM(A1:C12)

=SUM(A1; 3,14; 1,57)

Sums values within the list.

SUMSQ

=SUMSQ(B1:D1)

=SUMSQ(1; 2; 3; 4)        

Sums squares of values within the list.