View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hardeep.kanwar[_9_] hardeep.kanwar[_9_] is offline
external usenet poster
 
Posts: 1
Default 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