Multiple Summation. HELP!

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?
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

have an entire row populate with a link when the data in a cell ch 1
Formula to Enter Dates 5
Sort question?? 0
Tranportation query - interesting one 1
Help with file open and data organise macro 1
Help please with Offset/Match formula 2
Help with a formula - probably an "IF" 5
Compare and group like numbers and info 5

Top