Need a formula to count the duplication of a value in a range

Arzan - Nov 17, 2015 at 12:37 AM

I need a formula that can count the number of duplication of a particular value in a range of cells.
Example: I need to know the count of a1 in the below range.

A1: a1 a2 b1
A2: a1 a3 c2
A3: a1 c3 a1
A4: c2 a1 a1
A5: a1 b3
A6: a1 a1