Count cells that match criteria -- COUNTIF

[Way To Excel]

Dear Friends

Find the below function and its description for counting the specified contents from a range.

Match criterion exactly

In Excel, count cells that meet a specific criterion. In this example only the Pen orders will be counted.

1. Select the cell in which you want to see the count (cell A12 in this example)
2. Type an equal sign (=) to start the formula
3. Type:   COUNTIF(
4. Select the cells that contain the values to check for the criterion. In this example, cells A1:A10 will be checked
5. Type a comma, to separate the arguments
6. Type the criterion. In this example, you're checking for text, so type the word in double quotes:   "Pen"
   Note: upper and lower case are treated equally
   
7. Type a closing bracket
   The completed formula is: =COUNTIF(A1:A10,"Pen")
   
8. Press the Enter key to complete the entry
9. The result will be 4, the number of cells that contain "Pen"

--
---
Sixthsense
:) Man of Extreme & Innovative Thoughts :)