Working with functions. Skipping empty cellsWhen calculating averages, it is often required to skip empty cells (i.e. absent students) so that the average only takes into account those cells that actually hold a value
Our previous formula would consider an empty cell as 0 and the average's result would not be correct.
In short, a function works like this: you configure its input values - called arguments or variables - and it will yield a single result (its output)
You will find a short description under the Functions button and you will see how to work with it.
The function we need in our case is called Flexible average
The description of this FLEXAVERAGE function explains that it requires a variable number of arguments, hence the ellipsis and that it will automatically skip empty cells
This is how our previous formula would look with this function