Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumProduct Query
Hi! Experts What is the Difference Between these Sumproduct Function It show the Same Results What is the Difference Between "--" in First Function and "*" in Second Function 1st:SUMPRODUCT(--(A54:A61="Orange"),--(C54:C61="Friday"),--(D54:D61="Sam"),B54:B61) 2nd:SUMPRODUCT((A54:A61="Orange")*(C54:C61="Friday ")*(D54:D61="Sam")*B54:B61)) Thanks in Advance Hardeep Kanwar -- hardeep.kanwar ------------------------------------------------------------------------ hardeep.kanwar's Profile: http://www.thecodecage.com/forumz/member.php?userid=170 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=106459 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct query | Excel Worksheet Functions | |||
SUMPRODUCT QUERY | Excel Worksheet Functions | |||
SUMPRODUCT query | Excel Discussion (Misc queries) | |||
Sumproduct query | Excel Discussion (Misc queries) | |||
SUMPRODUCT Query | Excel Discussion (Misc queries) |