Multiple Summation. HELP!

  • Thread starter Thread starter Jafferi
  • Start date Start date
J

Jafferi

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?
 
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
 
Back
Top