Hi,
I was hoping if someone could help me for the following:
<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.
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.