Microsoft Excel COUNTIF Function Help
EMAGENIT Home page

Call us at:   1.805.498.7162     1.805.558.9277--

Learn about how we can help your company or yourself achieve your Microsoft Excel training or self-study goals Visit our free Microsoft Excel and Microsoft Excel VBA resource center Learn how we can help save your company money with our innovative software solutions Visit out VBA code center for code that can save your company money Learn about our Excel Add-In software that can save your company time and money View our customer list from our 12 years in business Phone numbers, request form and email address Learn about EMAGENIT View our training schedule for Microsoft Excel and Microsoft Excel VBA

 

COUNTIF Function Examples

COUNTIF Function Description

Counts the number of cells within a designated range that meet a specific criteria.

COUNTIF Function Syntax

=COUNTIF(range,criteria)

COUNTIF Function Argument Descriptions

range:  This is the range whose elements you wish to count. Can be a single column, row or a multi column/row range.

criteria:  This is the criteria to apply against the designated range It can be in the form of a number, formula, cell reference, or text that defines the cells to be counted. For example, criteria can be expressed as 32, "32", ">32", "apples", or B4.

COUNTIF Function Tips

  • For the criteria, you can use the wildcard characters like a question mark (?) or an asterisk (*). A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.
  • Use the COUNTIF function to detect the presence of a value in a column before using VLOOKUP or MATCH. You can use it as part of the logic argument for the IF Function.