Tips.Net > ExcelTips Home > Worksheet Functions > Statistical Functions
The following articles are available. Click the article's title (shown in bold) to see the associated article.
Adding Up Tops and Bottoms If you need to know the sum of the top X items in a list or the bottom X items, you can use the LARGE and SMALL functions. This tip shows how easy it is to use the functions in a formula. Microsoft Excel versions: 97 2000 2002 2003
Counting Cells with Specific Characters If you’ve got a long list of data and you want to count the number of cells in the range that begin with a specific character, putting together the proper formula can be a bit confusing. You can get just what you need by using the COUNTIF function, as illustrated in this tip. Microsoft Excel versions: 97 2000 2002 2003
Counting the Number of Blank Cells Do you want to know how many blank cells are within a range? You can use the COUNTBLANK function, described in this tip, to get the answer. Microsoft Excel versions: 97 2000 2002 2003
Counting with Formulas Do you need to quickly count items based on a specific criteria? You can use the COUNTIF function, as described in this tip, to make short work of your counting needs. Microsoft Excel versions: 97 2000 2002 2003
Counting with Two Criteria Want to count the records in a data table that match two criteria? It’s not as easy or straightforward as you might hope. This tip explores several different ways you can get the desired result. Microsoft Excel versions: 97 2000 2002 2003
Counting within Criteria Counting cells in Excel is easy; counting cells that meet a particular criterion is a bit more difficult. This tip explains how you can put together a formula that will count only those cells you want counted, based on one or more criteria that you specify. Microsoft Excel versions: 97 2000 2002 2003
Finding the Lowest Numbers Need to find the lowest numbers in a range of values? It’s easy to do using the SMALL worksheet function, or you can use a macro for more demanding needs. Microsoft Excel versions: 97 2000 2002 2003 2007
Phantom Counts Perplexed by the ways in which the COUNT and COUNTA functions seem to count? This tip explains the differences and the “gottchas” you need to watch for. Microsoft Excel versions: 97 2000 2002 2003 2007
Using GEOMEAN With a Large List GEOMEAN allows you to calculate the geometric mean of a series of values. This is easy with a limited number of values in your series, but can be a challenge with larger series. This tip discusses how to handle those large lists. Microsoft Excel versions: 97 2000 2002 2003 2007
Using the FORECAST Function The FORECAST worksheet function can be used to do an extrapolation of future data points based on a linear regression of existing data. This tip explains how to use the function. Microsoft Excel versions: 97 2000 2002 2003 2007
Have thousands of ExcelTips at your fingertips, on your own system. Answer your own questions or help support others. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site