A recent post in this site's forum ask a question about combining the AND function with the SUMIF function in order to add up data that met specific criteria in two other data ranges .

Rather than do this, a simpler way would be to use the SUMIFS function which is similar to SUMIF except that SUMIFS allows you to specify from 2 to 127 criteria ranges rather than just one.

For example, the function can be used to pick out data from specific years. This would allow you to add up only the profits for say 2006 and 2007 from a worksheet containing data from 2004 to 2009.

To find out the details, read the article on using the Excel 2007 SUMIFS Function.

Related Articles

• Excel 2007 SUMIF
• Excel 2007 COUNTIFS Function
• Excel 2007 IF Function

Two of the most useful functions available in Excel are the IF function and the SUM function:

• The IF function introduces decision making which adds flexibility to your to spreadsheets.
• The SUM function makes it easy to add up data located in rows or columns.

So useful are these two functions, that they have been combined into one - The SUMIF function.

SUMIF makes it easier to add up values if a certain criterion is met. The criterion can test the data to be summed or an entirely different range of data.

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

Related Articles

• Excel 2007 IF Function
• Excel 2007 SUM Function
• Excel 2007 SUMIFS Function

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

• Excel 2007 SUMIF
• Excel 2007 COUNTIF
• Excel 2007 IF Function

One Excel function that can be used to calculate the number of days between two dates is the EOMONTH function.

Short for End of Month Function, EOMONTH is mainly used to calculate the maturity date for investments that fall due on the last day of the month.

The function can also be used to find the start or end date for projects.

To find out the details of using this function, read the article on Excel 2007 EOMONTH Function.

Related Articles

• Sort by Date and Other Excel 2007 Date Options
• Excel 2007 EDATE Function
• Count Days Between Two Dates in Excel 2007