1

{=SUM(($C$3:$C$9=G3) * 1)}

2

{=DSUM(($C$3:$C$9=G3) * 1)}

3

{=SUM(IF($C$3:$C$9=G3, 1))}

4

{=COUNT(IF($C$3:$C$9=G3, 1))}