Windows 7 Ultimate Try it for free Count values t

You probably know how to use the COUNT function to count cells that contain a value. If you need a refresher on counting, see COUNT function, Ways to count values in a worksheet, and : 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, or that matches text? That's where the COUNTIF function comes in really handy.



To use COUNTIF,Office Home And Business 2010 Product Key, 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,Windows 7 Ultimate, 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,Microsoft Office Home And Business, and especially the "How it works" information. And because it's a live worksheet, 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,Windows 7 Enterprise 64, see COUNTIFS function.



And finally, if you already know about the COUNTIF function and use it on a regular basis,Office Home And Business, do you have any tips to share? We'd love to hear more about how people are using this function.



-- Gary Willoughby
<div