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.

Have a look at Aladin's explanation here...

http://www.mrexcel.com/board2/viewtopic.php?t=73205

Hope this helps!

In article ,
Dave F wrote:

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

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.

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.

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.

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.

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.

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.

Probably by curious minds of talented people who try things.

--
Don Guillett
SalesAid Software

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

Basically, it came about because people noticed things when they evaluated
formulae. They then thought 'what if I do that' and saw what happens when
they did. Bit by bit it evolved, so by combining curiosity with a basic
understanding of how things work in Excel, it has been possible to take it
further.

You might just as well ask why complex life of today has evolved from the
first fish that climbed out of the primordial swamp (and please don't
mention creationism!).


Bob

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