Double "-" in SUMPRODUCT

[Xilebo]

What is the purpose of the double "--" in the function SUMPRODUCT?

 

[Max]

It's to coerce the array of TRUEs/FALSEs returned into 1's/0's.

 

[Dave Peterson]

Some more resources:

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

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

 

[Gord Dibben]

All you ever need to know about SUMPRODUCT and the Unary operator(--) can be
found at Bob Phillips' site.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html


Gord Dibben MS Excel MVP