Learn how to find text inside cells, when the case of the text doesn't particularly matter.

Learn how to check if a cell contains text, when the case of the text is important.

In its simplest form, COUNTIF says: =COUNTIF (Where do you want to look?, What do you want to look for?) For example: The group of cells you want to count. Range can contain numbers, arrays, a …

Count how often a value occurs in Excel. Suppose you want to find out how many times particular text or a number value occurs in a range of cells. For example: If a range, such as A2:D20, contains the …

Excel contains several functions to help you count the number of cells in a range that are blank or contain certain types of data. Select the cell where you want the result to appear.

The third argument is the column in that range of cells that contains the value that you seek. The fourth argument is optional. Enter either TRUE or FALSE. If you enter TRUE, or leave the argument blank, …

For example, if you want to verify that a cell contains a numeric value instead of text before you perform a calculation on it, you can use the following formula:

This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get the same result. This article uses …

A query criterion is an expression that Access compares to query field values to determine whether to include the record that contains each value. For example, = "Chicago" is an expression that Access …

For example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5. You can use the following formula: =SUMIF (B2:B25,">5") Tips: If you want, you can …

A range of cells that contains text, numbers, or logical values that you want to compare with lookup_value. The array form of LOOKUP is very similar to the HLOOKUP and VLOOKUP functions.