Calculate How the Number of Specific word.

[Khalid A. Al-Otaibi]

Valid
Expired
Valid
Valid
Expired

Is there any way of how can I calculate the number of a word in a column?.

For Example I want to Calculate How many [Valid] in Column A.

 

[Ms-Exl-Learner]

Assume that you are having the below values in A Column

Row / Col A Col
Row1 Valid
Row2 Expired
Row3 Valid
Row4 Valid
Row5 Expired

CHOICE 1:-
Copy and paste the below formula in B1 Cell
=COUNTIF(A:A,A1)
Copy the B1 cell and paste it to the remaining cells of B Column based on
the A Column Data

CHOICE 2-
Copy and paste the below formula in C1 Cell
=A1&" "&COUNTIF(A:A,A1)
Copy the B1 cell and paste it to the remaining cells of C Column based on
the A Column Data