yunyuhue68
04-23-2011, 01:57 PM
You probably know how to use the COUNT function to count cells that contain a value. If you need a refresher on counting,Office Pro 2007 Key (http://www.windows7key.ca/office-2007-key), see COUNT function,Microsoft Office 2007 Pro (http://www.windows7serialkey.com/office-2007-key), Ways to count values in a worksheet, and Video: Count cells in Excel. But what if you want to count only the cells that meet a condition, such as being greater than or equal to a number or date you specify,Microsoft Office 2007 Key (http://www.office2007key.eu/), or that matches text? That's where the COUNTIF function comes in really handy. To use COUNTIF, you first specify the range that contains the values you want to count. Then you enter a criterion (condition) that's used as a test. Here's COUNTIF with both the range (B2:B5) and the criterion (">55"). The function inspects the range B2:B5, applies the condition "greater than 55," and then returns the number of values that meet the condition and displays that number in the worksheet. Pretty easy, plenty powerful. Below is a live worksheet, thanks to the Excel Web App embedding feature of Live.com. Take a look at the formulas, the description, the result,Office 2010 Professional Key (http://www.windows7serialkey.com/office-2010-key), and especially the "How it works" information. And because it's a live worksheet,Buy Office 2007 (http://www.msoffice2010key.com/office-2007-key), you can practice right here by entering formulas of your own. You can download this workbook by clicking the View full-size workbook button in the lower-right corner of the embedded workbook (at the right end of the black bar, above). Clicking the button loads the workbook in a new browser window (or tab),where you'll see a Download button. Note that you can't type in the worksheet cells in the full size view. For information about advanced settings for embedding a workbook, see Customize how your Excel workbook is embedded. To learn more about COUNTIF, see COUNTIF function. To learn about an even more powerful function introduced in Excel 2007 that lets you use multiple criteria and ranges, see COUNTIFS function. And finally, if you already know about the COUNTIF function and use it on a regular basis, do you have any tips to share? We'd love to hear more about how people are using this function. -- Gary Willoughby <div