| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summation Operator | Excel Worksheet Functions | |||
| Summation | Excel Discussion (Misc queries) | |||
| summation | Excel Worksheet Functions | |||
| Summation and Lookup | Excel Discussion (Misc queries) | |||
| Summation from a to b | Excel Worksheet Functions | |||
![Jafferi[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
