G
Guest
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
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