Count IF Formula

[John]

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

 

[Bernard Liengme]

I can see that HHH appears 3 times in A and AGB twice.
How are the other columns involved
Maybe this is no a true representative subset of the data
best wishes

 

[Sean Timmons]

In D1:

=countif(A:A,B1)

and paste down.

 

[John]

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

 

[John]

Hi Pete, 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

 

[Pete_UK]

I'm not sure what you meant when you said you wanted to count column
B, but the formula will give you the answers that you quote in your
example.

Look in XL Help for COUNTIF, and you will see that the syntax you
quote is not correct.

Perhaps if you describe your requirements again and give realistic
values in B then we might be able to get a bit nearer to what you
want. Could it be that you only want to count the conditions if B is
not empty?

Pete