PDA

View Full Version : Solved: explain formula



anandbohra
07-24-2007, 10:52 PM
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
07-25-2007, 12:43 AM
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
07-25-2007, 01:08 AM
See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed explanation.

anandbohra
07-25-2007, 01:36 AM
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
:rofl::rotlaugh: