Hi

I wonder if anyone can help me with the following problem.

I have two tabs within a worksheet. The second has a number of colums
including those shown below:

Name Date Value
Smith 11/12 N
Jones 11/05 D
Smith 11/20 D
Smith 11/08 N

I want to display (on the first tab) a total of how many times the Name =
Smith and the Value = N, which should return a value of 2 from the example
above. However, I can't get anything to work.

Any help would really be appreciated
--
Stormin