How to count cells containing specific value corresponding to a value in a different Column.

[Xlitup]

Hi,

I was hoping if someone could help me for the following:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Q[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Q[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]S[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Q[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]S[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Q[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

If the cell in Column A is equal to P then count cells containing the value 3.
So the above table consists of 5 Ps out of which 3 cells in Column B contains the value 3.

How can I put this in formula as I would further do this for other letters in Column A too.

Cheers.

 

[Tetra201]

Try

=COUNTIFS(A:A,"P",B:B,3)

 

[Xlitup]

Hey Testra201,

Thanks mate that seem to have worked fine, as I was trying that and it just kept giving the wrong values.

Cheers.