The AVERAGE function has two sister functions: AVERAGEA and AVERAGEIF.
Let’s take a look at them.
AVERAGEA is simple: it’s exactly the same as AVERAGE, but it can also handle TRUE and FALSE values. TRUE is counted as 1, and FALSE is counted as 0.
AVERAGEIF is a bit different, and it has some awesome uses.
It allows you to average a subset of cells based on some criteria.
Want to know how to use AVERAGEIF like a pro? Here’s a great example.
On the second sheet of the example workbook, you’ll see a list of sales amounts, along with “YES” or “NO” values for whether they’ve been completed.
Let’s use AVERAGEIF to average only the sales that have been completed. Here’s the syntax you’ll need: