## Some Simple Excel Functions

There are many, many Excel functions available, but initially the following functions might prove useful:

Some of the following are functions that take a range, like $C3:C7$ or something similar. For the examples discussed below, we use $R$ and $R_i$ to denote ranges of cells. Further, for the purpose of making sense of the example calculations, let us suppose some specific $R_i$ ranges are filled with the following:

$$R_1 : \{4,6,7,-3\}, \quad \quad R_2 : \{6,8,-5,7\}, \quad \quad R_3 : \{5, \textrm{""}, \textrm{"A"}, 6, -1\}$$
ABS(x)

Absolute value of $x$

SQRT(x)

Square Root of $x$

SUM($R$)

Sum of the elements in range $R$. Example:
$\textrm{SUM}(R_1) = 4 + 6 + 7 - 3 = 14$

AVERAGE($R$)

Average of the elements in range $R$. Example:
$\textrm{SUM}(R_1) = (4 + 6 + 7 - 3) / 4 = 3.5$

SUMSQ($R$)

Sum of the squares of the elements in range $R$. Example:
$\textrm{SUMSQ}(R_1) = 4^2 + 6^2 + 7^2 + (-3)^2 = 110$

PRODUCT($R$)

Product of elements in range $R$. Example:
$\textrm{PRODUCT}(R_1) = 4 \cdot 6 \cdot 7 \cdot (-3) = -504$

COUNT($R$)

Count of numeric elements in range $R$. Example:
$\textrm{COUNT}(R_3) = 3$

COUNTA($R$)

Count of non-empty elements in range $R$. Example:
$\textrm{COUNTA}(R_3) = 4$