I want to find out the number of rows where the more than one column meets
criteria set in another cell.

Eg:

Column A is Name
Column B is Date

I want to find out the number of times "John" appears in column A and
"14/07/06" appears in column B. If possible i'd like to reference the search
criteria through another cell.

My limited understanding makes me think I need a COUNTAND function but it
doesn't exist.

Thanks in advance for any help.

Regards

Barrie