View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default using -- with SUMPRODUCT

Can someone explain to me the difference between using -- and using * in the
following formula?

=SUMPRODUCT(--(H$2:H$65),--($F$2:$F$65=$G86)) vs.
=SUMPRODUCT((H$2:H$65)*($F$2:$F$65=$G86))

Does one of these operators have any benefit over the other?

Not sure it matters for this question but H2:H5 are dollar values, F2:F65
are project names, and G86 is a project name. Both formulas above give the
same, correct, result.

Thanks for any insight.

Dave
--
Brevity is the soul of wit.