# Counting Matching Occurrences From Multiple Columns

Feb 1, 2007I have a sheet with data which is all sorted by columns.

What I want to be able to count the occurrence of an instance when 2 cells in the same row (but in different columns) match my given criteria.

Ive been using 'countif' to count the instances in a single column and I am now aware that this is about all it can be used for.

An example of my data is:

A B

1 a

1 a

1 c

2 d

2 c

3 b

3 b

3 c

3 d

What I want to be able to count for example is how many times '3' & 'b' occur on the same row (in this case the answer would be 2).

Im not very good with pivot tables and have tried but have not managed to find an answer. I really hope that someone can help as Ive been working on this probelm for days and quite frankly its doing my head in :-)