Using CountIF Formula in Excel

=CountIF(A:A,"Test")
The formula above will count the number of times the value Test appears in the whole of column A and also display the number.

Read More..