• This article describes the formula syntax and usage of the COUNTIF function (function: ... Use functions to simplify and shorten formulas on a worksheet
• COUNTIFS function - Excel - Office.com - Microsoft Home Page ...

  2/27/2013

  Use functions to simplify and shorten formulas on a worksheet, ... COUNTIF function. Math and trigonometry functions (reference) Statistical functions (reference)
• COUNTIF function - Excel - Office.com

  2/27/2013

  The key to using the COUNTIF function (and other similar functions) successfully is understanding the wide variety of criteria that Excel will accep
• SUMIF function - Excel - Office.com - Microsoft Home Page ...

  2/27/2013

  Use functions to simplify and shorten formulas on a worksheet, ... COUNTIF function. IF function. Math and trigonometry functions (reference) SUM function.
• COUNTIFS function - Excel - Office.com - Microsoft Home Page ...

  2/27/2013

  Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel. Description.
• Using SUM(IF()) as an array function instead of COUNTIF() with AND ...

  2/27/2013

  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 ...
• SUMIF, COUNTIF, COUNTBLANK Return #VALUE! Error - Microsoft Support

  2/27/2013

  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 ...
• COUNT function - Excel - Office.com - Microsoft Home Page ...

  2/27/2013

   
  The worksheet function Countif may return an incorrect result when the criteria is set to blank ("").
• IF function - Excel - Office.com - Microsoft Home Page | Devices ...

  2/27/2013

  Excel provides additional functions that can be used to analyze your data based on a condition. ... use the COUNTIF or the COUNTIFS worksheet functions.
• Ways to count values in a worksheet - Excel - Office.com

  2/27/2013

   
  Use the COUNTIF function to perform this task. Example. ... Count how often multiple number values occur by using functions.
• Count numbers or dates based on a test - Excel - Office.com

  2/27/2013

  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 ...
• COUNT function - Excel - Office.com - Microsoft Home Page ...

  2/27/2013

  ... 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.

See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets