Try

=COUNTIF(A1:A5,"5000")+COUNTIF(B1:B5,"005")

Mike


"Gunti" wrote:

Hi,
I've got the following list:

A B
4999 005
5000 001
5000 003
5000 004
5000 005

I want Match to both find 5000 in column A and find 005 in column B,
returning 6 in this case.

Is this possible?

greets