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.

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.

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.

thanks Bob....I am not mentioning about creationism, which is part of our
daily lives, what I specifically bothered of is if this evolved and
pronounced creation will never be apprehended by future versions of excel, i
dont know any software re-structuring, just a simple user..The big question
is, will this sumproduct formula structuring be readable in future ms
upgrades 2010,etc....

"Bob Phillips" wrote:

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.

SUMPRODUCT is usable in XL 2007 and I see no reason why it would be
deprecated in 2010, 20100, 201000, or any other year.

Dave
--
Brevity is the soul of wit.


"driller" wrote:

thanks Bob....I am not mentioning about creationism, which is part of our
daily lives, what I specifically bothered of is if this evolved and
pronounced creation will never be apprehended by future versions of excel, i
dont know any software re-structuring, just a simple user..The big question
is, will this sumproduct formula structuring be readable in future ms
upgrades 2010,etc....

"Bob Phillips" wrote:

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.

I think it will because it uses structures that are part of other functions,
in other words part of the fundamental architecture. Not a guarantee I
agree, but enough for me to worry about it.

--

HTH

Bob Phillips

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

"driller" wrote in message
...
thanks Bob....I am not mentioning about creationism, which is part of our
daily lives, what I specifically bothered of is if this evolved and
pronounced creation will never be apprehended by future versions of excel,
i
dont know any software re-structuring, just a simple user..The big
question
is, will this sumproduct formula structuring be readable in future ms
upgrades 2010,etc....

"Bob Phillips" wrote:

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.