View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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