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:

Column A	Column B
P	3
P	1
Q	3
P	3
Q	1
S	1
Q	3
S	3
P	1
P	3
Q	1

<tbody>
</tbody>

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.