Exactly what I was looking for, thanks.

Dave
--
Brevity is the soul of wit.


"Bob Phillips" wrote:

They are identical in this case, but sometimes there are subtle differences.

See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.



--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Dave F" wrote in message
...
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.