Difference Between "--" and "*" in Sumproduct
Could anybody tell me the difference between "--" and "*" in Sumproduct with
Example If Possible with Example Thanks in Advance |
Difference Between "--" and "*" in Sumproduct
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 |
Difference Between "--" and "*" in Sumproduct
-- 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 |
Difference Between "--" and "*" in Sumproduct
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 |
All times are GMT +1. The time now is 09:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com