I am using Excel 2000 and Windows XP. I have 2 worksheets. The first
worksheet has the formula I am trying to create. The second worksheet has 2
columns, the first column has the values A5/4, A6/4 etc. the second column
has various values eg OP, BS etc I am trying to use COUNTIF in the first
worksheet to count the number of times A5/4 AND OP occurs in the same row.

Many thanks in advance.
--
Richard