Wednesday November 18, 2009
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
Monday November 16, 2009
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
Friday November 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
Wednesday November 11, 2009
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