Averaging non-zero values
Here is a simple trick to exclude zero-valued cells from functions where it might be desired - for example the AVERAGE function.
In the example below, we average the sales figures over a number of counties. That is straightforward =AVERAGE(Range)
However, by using the ever-so-useful COUNTIF together with the SUM function, we can instead just average the non-zero values.
