You are looking at SUMPRODUCT, but not on whole columns, just part

=SUMPRODUCT(--(A1:A100="val1"),--(B1:B1000=123))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"=countif(data!A:A, 001 ,andif (data!B:B," <=countif(data!A:A,"001",andif
wrote in message
...
Hello, I am looking for a the proper function in excel that would allow me
to
count if a criteria is matched in column "A" and if another criteria is
matched in column "B".