using -- with SUMPRODUCT

G

Guest

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
 
G

Guest

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

Guest

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
 
G

Guest

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

Bob Phillips

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
 
G

Guest

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

Guest

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
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Defined Names in a Formula 1
This One Is Tricky Need Help !!!!! 1
SUMPRODUCT HELP 2
Problem with SUMPRODUCT 6
SUMPRODUCT with criteria including OR function 4
Sumproduct with OR 7
Multiple criteria for sumproduct 4
Help with SUMPRODUCT 2

Top