Use Msdn to search the Web.uuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=47442013-02-27T11:28:11Zuuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4745

COUNTIF(range,criteria) ... Microsoft Excel provides additional functions that can be used to analyze your data based on a condition.<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/ui3yClLtwTw" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://office.microsoft.com/en-us/excel-help/countif-HP005209029.aspxuuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4746

Use functions to simplify and shorten formulas on a worksheet, ... The COUNTIF function counts the number of cells within a range that meet a single criterion that you ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/nNd-5YUxMtE" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://office.microsoft.com/en-us/excel-help/countif-function-HP010069840.aspxuuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4747

This article describes the formula syntax and usage of the COUNTIF function (function: ... Use functions to simplify and shorten formulas on a worksheet, ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/l3wh6OsNOMo" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://office.microsoft.com/en-us/excel-help/countif-function-HP010342346.aspxuuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4748

Use functions to simplify and shorten formulas on a worksheet, ... COUNTIF function. Math and trigonometry functions (reference) Statistical functions (reference)<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/uNXVNnPr2pA" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://office.microsoft.com/en-us/excel-help/countifs-function-HA010047494.aspxuuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4749

This article describes the formula syntax and usage of the COUNTIF function (function: ... Use functions to simplify and shorten formulas on a worksheet, ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/j4ERD8L4Gh4" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://office.microsoft.com/en-us/excel-help/countif-function-HA102753077.aspxuuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4750

The key to using the COUNTIF function (and other similar functions) successfully is understanding the wide variety of criteria that Excel will accept.<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/TqVhwDmDxBI" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://office.microsoft.com/en-us/excel-help/use-the-countifs-function-in-excel-2007-to-analyze-data-HA010236993.aspxuuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4751

Use functions to simplify and shorten formulas on a worksheet, ... COUNTIF function. IF function. Math and trigonometry functions (reference) SUM function.<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/PHbqWg0Haio" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://office.microsoft.com/en-us/excel-help/sumif-function-HP010062465.aspxuuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4752

Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel. Description.<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/TqiPo3amSVw" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://office.microsoft.com/en-us/excel-help/countifs-function-HA010342347.aspxuuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4753

In Microsoft Excel, the COUNTIF() function allows you to determine the number of cells in a range whose values match a certain criterion, but it does not ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/om4Bg8EbjEU" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://support.microsoft.com/kb/275166uuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4754

A formula that contains the SUMIF, COUNTIF, or COUNTBLANK functions may return the #VALUE! error in Microsoft Excel. Note This behavior also applies to the ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/ODCxn58XvyI" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://support.microsoft.com/kb/260415uuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4755

If you want to count only numbers that meet certain criteria, use the COUNTIF function or the COUNTIFS function. Example. ... Statistical functions (reference)<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/xKAOKzWJEIE" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://office.microsoft.com/en-us/excel-help/count-function-HP010062492.aspxuuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4756

Microsoft Office Excel provides additional functions that you can use to analyze your data based on a condition or criteria: ... use the COUNTIF function.<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/HzJ9yOHA3ig" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://office.microsoft.com/en-us/excel-help/sumif-HP005209292.aspxuuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4757

The SUMIF and COUNTIF functions return incorrect results when you use them to match strings longer than 255 characters to the string #VALUE!.<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/Dk-KW6U0Uuk" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://support.microsoft.com/kb/231114uuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4758

Show All Hide All To count numbers greater than or less than a number, use the COUNTIF function. To count numbers that fall between a range of numbers, you can use ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/q3mZwfdeB1o" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://office.microsoft.com/en-us/excel-help/count-numbers-greater-than-or-less-than-a-number-HP003056117.aspxuuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4759

The worksheet function Countif may return an incorrect result when the criteria is set to blank ("").<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/PyZzU1ywD_U" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://support.microsoft.com/kb/161757uuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4760

Excel provides additional functions that can be used to analyze your data based on a condition. ... use the COUNTIF or the COUNTIFS worksheet functions.<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/faqBwQtQ_mU" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://office.microsoft.com/en-us/excel-help/if-function-HP010069829.aspxuuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4761

You can count unique values in a range by using a PivotTable report, the COUNTIF function, a combination of functions, or by using the Advanced Filter dialog box.<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/11aaJa7uJxY" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://office.microsoft.com/en-us/excel-help/ways-to-count-values-in-a-worksheet-HA010351132.aspxuuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4762

Use the COUNTIF function to perform this task. Example. ... Count how often multiple number values occur by using functions.<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/xKa7uzsPrSY" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://office.microsoft.com/en-us/excel-help/count-how-often-a-value-occurs-HP001127779.aspxuuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4763

See examples of how to use worksheet functions to count numbers or dates that fall within a range in ... The COUNTIF function counts the number of cells in the ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/3FnZLjnhC5E" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://office.microsoft.com/en-us/excel-help/count-numbers-or-dates-based-on-a-test-HP010342341.aspxuuid:698150c0-645d-4d45-b6d9-5131d01d4cd0;id=4764

... and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, ... use the COUNTIF function or the COUNTIFS function. Example.<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/6OEFi03w-0g" height="1" width="1"/>

2013-02-27T11:28:11Zhttp://office.microsoft.com/en-us/excel-help/count-function-HP010342338.aspx