yah dave. Nowadays...software is built within a car...

"Dave F" wrote:

Software is not a car...
--
Brevity is the soul of wit.


"driller" wrote:

just wondering when does the sumproduct formula structuring been developed ?
and how come that other's had amazingly knew it and expose it ?
In simple words, If I by a cr, the manufacturer has to show in the dashboard
about the speed limit/specs etc., ain' it? Do i have to get another mechanic
to check it out?
just really wondering why this happens, Yah its real world indeed.
"Dave F" wrote:

My experience is that the XL help files are very rudimentary. For a better
explanation of SUMPRODUCT I would use the links supplied by either Domenic or
Bob.

Dave
--
Brevity is the soul of wit.


"driller" wrote:

thanks Dave F. for bringing up this question....I agree that there are Excel
users that are not aware of this so-so operand...Can someone guide us where
to find it in the help files of standard excel....i am using Excel 2003....i
do not know if this so-so operand is guaranteed by excel programmers.
I cant even find an example of Dave's formula from help files with an =
conditioning...the help files guarantees the array1,array2,....multiplication
only...how we know an excel's guaranteed result of a conditional array under
the Sumproduct function ?
Please verify coz we find a bunch of excel reply on posted questions like
what Dave had provided. An end user will be more than happy if there are
links from Excel support to explain this....

"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.