Hello. Here's the scenario:

I have a list of numbers in Colum A, and a list in Colunm B.
A B
1 2
1 1
2 1
3 1
4 2
1 2
3 1

I want to count the number of cells in Column B with a certain value (say
'2'), but only if the adjacent cell in column A contains a certain value (say
'1'). Can anyone help?

Thanks a million,
Rachel.