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

If Possible with Example

Thanks in Advance

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
---------------
Jacob Skaria


"Hardeep kanwar" wrote:

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

If Possible with Example

Thanks in Advance

-- 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

--
David Biddulph

"Hardeep kanwar" wrote in message
...
Could anybody tell me the difference between "--" and "*" in Sumproduct
with
Example

If Possible with Example

Thanks in Advance

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(()*()*()).


"Hardeep kanwar" wrote:

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

If Possible with Example

Thanks in Advance