Saturday January 28, 2012
Excel COUNTIF Function © Ted French
Excel's COUNTIF function combines two other commonly used functions - the COUNT function and the IF function.
The result is that COUNTIF will only count cells containing data that meet a condition that you have specified.
COUNTIF can be used for such things as finding out how many customers have made purchases in the past month, or how many employees work in the East sales region.
To find out the details of using this function read the
Excel COUNTIF Function Step by Step Tutorial.
Related Tutorials
Tuesday January 24, 2012
Excel's SUMIFS
function is similar to the
SUMIF function except that it is used to add up
data only if specific criteria are met in two or more
ranges of
cells.
The function can be used to pick out data for specific years - allowing you, for example, to add up only the profits for the year 2006 and 2007 from a worksheet containing data from 2004 to 2008.
To find out the details, read the step by step tutorial on using the
Excel SUMIFS Function.
Related Step by Step Tutorials
Thursday January 19, 2012
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 will add up values if a certain criterion is met. You get to specify the criterion to be used and also the data to be summed.
To find out more, read this step by step tutorial on the Excel SUMIF Function.
Related Step by Step Tutorials
Monday January 16, 2012
The TRUNC function in Excel is similar to the
INT function in that they both remove all decimal places from a number leaving only the whole number.
How they differs is that while the INT function rounds the remaining whole number down, the TRUNC function does no rounding at all.
Removing extra decimal places can make it easier for yourself or others to read and understand the data.
To find out how to use this function, read the short tutorial on the Excel TRUNC Function.
More Rounding Number Functions
