Topic: 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

Tips, Tricks, and Answers

Save Time!

Helpful Links

Great Info!

RSS Feeds