Hi Sean, thanks for the answer however I want to be able to write like
"SUMIF" but for "COUNTIF". =Countif(A:A,C2,B:B), I tried this formula and
does not work

"Sean Timmons" wrote:

In D1:

=countif(A:A,B1)

and paste down.

"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