Double "-" in SUMPRODUCT
 

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

Double "-" in SUMPRODUCT
 

It's to coerce the array of TRUEs/FALSEs returned into 1's/0's.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Xilebo" wrote:
What is the purpose of the double "--" in the function SUMPRODUCT?

Double "-" in SUMPRODUCT
 

Some more resources:

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

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



Xilebo wrote:

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

--

Dave Peterson

Double "-" in SUMPRODUCT
 

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

On Sat, 17 Feb 2007 17:02:00 -0800, Xilebo wrote:

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