1. Computing
Ted French

Excel AVERAGEIFS Function

By September 5, 2013

Follow me on:

In addition to the AVERAGEIF function mentioned in the last post, there is also an AVERAGEIFS function in Excel.

Both functions combine the operations of AVERAGE and IF functions

Where they differ is in the number of criteria that each function can match.

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

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.