Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - How to count how many cells in excel contain the same letter
How to count how many cells in excel contain the same letter

1. You can use the COUNTIF function with wildcards to perform statistics

Suppose you want to find the number of cells containing the letter "A" in column A, then you can find the number of cells containing the letter "A" in column B1. Write the formula

=COUNTIF(A:A,"*A*")

2. Definition of related functions in the formula

(1) COUNTIF function

Calculate the number of cells in the range that meet the given conditions.

Syntax

COUNTIF(range,criteria)

Range is the cell range in which the number of cells that meet the criteria needs to be calculated.

Criteria are criteria that determine which cells will be counted and can be in the form of numbers, expressions, or text. For example, the condition could be expressed as 32, "32", ">32", or "apples".

Description

Microsoft Excel provides additional functions that you can use to analyze data based on conditions. For example, to calculate the sum based on a text string or a range of numbers, use the SUMIF worksheet function. To have a formula return one of two values ??based on a condition, such as a sales bonus for a specified sales volume, use the IF worksheet function.

(2) The * symbol is used as a wildcard in this formula and can replace multiple characters.