1. Computing
Ted French

Excel AVERAGEIFS Function

By February 2, 2012

Follow me on:

Like the SUMIF and SUMIFS functions below, there is also an AVERAGEIF and AVERAGEIFS functions in Excel.

The difference between these two functions that combine the AVERAGE and IF functions is the number of criteria that must be matched before a data record is included in the average.

AVERAGEIF looks to match a single criterion while AVERAGEIFS can be used to match from two to 127 criteria ranges.

AVERAGEIFS could be used to pick out data for specific years - allowing you, for example, to average only the profits for the years 2007 and 2009 from a worksheet containing data for the years 2006 to 2010.

To find out more, read the step by step tutorial on the Excel AVERAGEIFS Function.

Related Step by Step Tutorials

Comments
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.