carlyman Wrote:
I keep seeing "--" in sumproduct functions: =SUMPRODUCT(--(A1:A100....

What does the "--" mean/do?

Have a look at the following link...

http://www.mcgimpsey.com/excel/formulae/doubleneg.html

Hope this helps!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=379110