Using Excel's COUNTIF() Function

 To use Excel's COUNTIF() function, which counts the number of cells within a range that meet a specified condition, follow these steps:

Open Excel: Launch Excel and open the worksheet containing the data you want to analyze.

Select a cell: Click on the cell where you want the result of the COUNTIF() function to appear.

Type the function: In the selected cell, type =COUNTIF( to start the function.

Specify the range: After typing =COUNTIF(, specify the range of cells you want to evaluate. This is the range where you want Excel to count the cells.

Enter the criteria: After specifying the range, enter the criteria that you want Excel to use for counting. This can be a specific value, expression, or text string. For example, if you want to count the number of cells in the range A1:A10 that contain the value "Apples", you would enter "Apples".

Close the function: Close the parentheses ) to complete the function.

Press Enter: After closing the parentheses, press Enter to execute the function. The result will appear in the selected cell, showing the count of cells within the specified range that meet the specified condition.

Here's an example:

Suppose you have a list of fruit names in cells A1:A10, and you want to count how many times "Apples" appears in the list.

=COUNTIF(A1:A10, "Apples")

This formula will count the number of cells in the range A1:A10 that contain the value "Apples" and display the count in the selected cell.