Didn't see or open any attachments, but basic principle

=SUMPRODUCT(--(A2:A200="value1"),--(B2:B200=value2))

one text test, one numeric test

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"kevink79" wrote in
message ...

Hello i got this problem in Excel. Can you please to give me the
function or any tip to do that ? The attach filed consists of a table
and question.

Thanks so much


+-------------------------------------------------------------------+
|Filename: Question.doc |
|Download: http://www.excelforum.com/attachment.php?postid=3918 |
+-------------------------------------------------------------------+

--
kevink79
------------------------------------------------------------------------
kevink79's Profile:
http://www.excelforum.com/member.php...o&userid=28200
View this thread: http://www.excelforum.com/showthread...hreadid=477425