Solved: explain formula

[anandbohra]

Hi friends,
yesterday while searching for excel files i found this file in www.contextures.com.
pl explain me the syntax used in this sumproduct formula

=SUMPRODUCT(--(ColourList=B18),(UnitsList),--(DateList>=$C$2),--(DateList<=$E$2))
what does this -- stands for

[unmarkedhelicopter]

This is known as a double uniary.
if you have a number (say) 7 and you apply a duble uniary you get 7.
Well what was the point of that ?
Well if you have TRUE and you apply a double uniary you get 1
And False you get 0
So it is often used to get boolean values to determine the outcome of a calculation.

[Bob Phillips]

See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed explanation.

[anandbohra]

THanks for your replies


thansk XLD this link provides me lots of information about sumproduct.


thanks to all of you who devoted their precious time in solving my query