[Solved] How to count the occurrences of cell contents?

Why not a simple formula?

Presuming your range is C1:H3and the first
value-to-check is in C6

=COUNTIF($C$1:$H$3, C$6)

Will produce the expected result