Difference Between "--" and "*" in Sumproduct

[Hardeep kanwar]

Could anybody tell me the difference between "--" and "*" in Sumproduct with
Example

If Possible with Example

Thanks in Advance

 

[Jacob Skaria]

J.E. McGimpsey has some notes at
http://mcgimpsey.com/excel/formulae/doubleneg.html

Bob Phillips explains =sumproduct() in much more detail here
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

If this post helps click Yes

 

[David Biddulph]

-- needs a comma too.

=SUMPRODUCT(--(A2:A10=A1),B2:B10)
=SUMPRODUCT((A2:A10=A1)*B2:B10)

Double unary minus:
a.. http://www.mcgimpsey.com/excel/formulae/doubleneg.html
b.. http://xldynamic.com/source/xld.SUMPRODUCT.html

 

[JLatham]

The --() with comma format of the function operates faster than the () * ()
format. Just thought I'd throw that in as added information.

If you have just a few 'special' SUMPRODUCT() formulas in a workbook it
probably doesn't affect performance a log, but if you have hundreds or
thousands of them, then using the SUMPRODUCT(--(),--(),--()) format could
have a performance advantage over SUMPRODUCT(()*()*()).