ExcelBanter - Multiple Summation. HELP!

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Multiple Summation. HELP! (https://www.excelbanter.com/excel-worksheet-functions/226420-multiple-summation-help.html)

Jafferi[_2_]

Multiple Summation. HELP!

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?

Jacob Skaria

Multiple Summation. HELP!

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?

All times are GMT +1. The time now is 07:33 PM.