Use this formula

=SUMPRODUCT(--($B1:$B6=1233),--($C1:$C6="M.Book"))

Replace 1233 with A1 and "M.Book" with the cell reference

If this post helps click Yes
---------------
Jacob Skaria


"Jafferi" wrote:

A
1233

B C
1233 M.Book
1233 B.Book
1233 M.Book
1212 M.Book
2222 M.Book
1212 B.Book

By pointing at cell A, how can excel formula giving me the results that
1233 has 2 = M.Book?