SUMPRODUCT Qusetion
No difference.
Google for:
"double unary minus" Excel sumproduct
--
David Biddulph
"QuietMan" wrote in message
...
What is the difference between these two formulas?
sumproduct((RangeA=CriteriaA)*(rangeB=CriteriaB)*( SumRange))
sumproduct(--(RangeA=CriteriaA),--(rangeB=CriteriaB),--(SumRange))
What exactly "--" represent?
Thanks
--
Helping Is always a good thing
|