Hello All,

Imagine the spreadsheet:

... A B

1. 0 J

2. 1 K

3. 1 J

4. 0 L

5. 1 L

I want a formula that states:

Count all the cells in column B that contain "J" IF column A = 1. So the result of the formula for the above sheet would be 1 (cell B3 only).

I'm trying to knock together a formula with COUNTIF and the AND operator without much success.

Can someone give me a pointer please?

Thanks in advance,

Ben