Here we have a list of 16 properties with prices and other information.
TheAVERAGEIFS functioncan calculate an average for cells that meet multiple criteria.
The first argument isaverage_range;this is the range that contains the values to average.
The criteria is supplied in pairs: first therange, and then thecriteria.
To start off, let’s calculate a straight average with theAVERAGE functionfor reference.
LikeAVERAGEandAVERAGEIF, theAVERAGEIFS functionwill automatically exclude blank values, but zero values are included.
Let’s calculate an average that excludes zero values.
Next, we need to calculate an average for prices greater than zero and less than $500,000.
Using the status bar, I can quickly verify that we do, indeed, have the right average.
TheAVERAGEIFS functionwill throw an error if no values in the range meet the criteria.
