View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Quietman Quietman is offline
external usenet poster
 
Posts: 109
Default SUMPRODUCT Qusetion

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