1. Home
  2. Computing & Technology
  3. Spreadsheets
photo of Ted French
Ted's Spreadsheets Blog

By Ted French, About.com Guide to Spreadsheets

Excel 2007 AVERAGEIF

Wednesday May 13, 2009
One of Excel's Something - If functions is the AVERAGE IF function.

AVERAGE IF combines two very useful and well used functions - the IF function and the AVERAGE function.

The AVERAGE function is used to find the average value in a range of data while the IF function allows you to have different result occur depending on whether a specific condition is met or not.

AVERAGE IF makes it easier to find the average value if specific criteria are met. This makes it possible to set up trigger cells in a spreadsheet so that the data is averaged only when a certain level is reached.

To find out more, read the short article on the Excel 2007 AVERAGEIF function.

Related Articles
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>

Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets

©2009 About.com, a part of The New York Times Company.

All rights reserved.