count/find with 2 criterias

Hi guys,

thanks for any response in advance..
This is probably really easy, but i cant work it out.

I want to match 2 cells in 1 row and give an "x" or number or highlight in a 3rd cells
Example:

in col C tell me if both criteria matches
Col C = [ if Col A = X ] & [ Col B = 2 ]
excel.xlsx
i've added a workbook. Hope this makes sense,

Thanks for any assistance.
=)

Hi Ngocpdn, try this function, which works in Excel 2007+

=COUNTIFS(A:A,"x",B:B,2)

That will give you a total of how many rows have both an "x" in column A and a 2 in column B. If you want to just check each row for those criteria, then (assuming your data starts in row 2), in C2 use:

=AND(A2="x",B2=2)

Fill that down as many rows as needed. This will return TRUE (if both conditions are met) or FALSE (if either condition fails).