Try this in D1 (next to AGP):

=COUNTIF(A:A,C1)

and then copy down as required.

Hope this helps.

Pete

On Nov 17, 8:42*pm, John wrote:
Hi All,

I have a problem below. I need to count if the value in column C equal to
value in column A then count column B. In this case "AGB" should be "2" and
"HHH" should be "3".

Column A * * * * Column B * * * * *Column C
HHH * * * * * * * * * *10 * * * * * * * * * * AGB
AGB * * * * * * * * * *10 * * * * * * * * * * HHH
HHH * * * * * * * * * *10 * * * * * * * * * * NNN
HHH * * * * * * * * * *10 * * * * * * * * * * MMM
AGB * * * * * * * * * * 10 * * * * * * * * * *BBB
* *. * * * * * * * * * * * *. * * * * * * * * * * * * .
* *. * * * * * * * * * * * *. * * * * * * * * * * * * .
* *. * * * * * * * * * * * *. * * * * * * * * * * * * .

Thank you
John