| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumProduct question
Dear all,
A B 1 Item Number 2 x 1 3 y 2 4 x 3 SumProduct(--(A1:A4="x"),(B1:B4)) gives the correct answer 4. However, SumProduct((A1:A4="x"),(B1:B4)) gives the incorrect answer, it incorrectly gives 0. Any idea why? Thanks, Wing |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumProduct Question | Excel Discussion (Misc queries) | |||
| SumProduct Question | Excel Worksheet Functions | |||
| Sumproduct question | Excel Worksheet Functions | |||
| SumProduct question | Excel Discussion (Misc queries) | |||
| SUMPRODUCT question | Excel Worksheet Functions | |||
Threaded Mode
