Excel COUNTIF Function
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 ... Read More
Excel SUMIFS Function
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 ... Read More
Excel SUMIF Function
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 ... Read More
Excel TRUNC Function
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 ... Read More
Excel IF Function Step by Step Tutorial
Thursday January 12, 2012
The Excel IF function adds flexibility to your spreadsheets by introducing decision making. It does this by testing a specified condition in your spreadsheet to see if it is true ... Read More
Rounding Numbers with the CEILING Function
Friday January 6, 2012
The CEILING function in Excel is similar to the ROUNDUP Function in that they both round the last digit upwards.
How they differs is that while the ROUNDUP function only ... Read More
Keeping Headings and Titles on Screen in Excel
Monday January 2, 2012
When working with large spreadsheets, it gets a bit frustrating, when you go to read the data in a distant row or column and the headings at the top of ... Read More