Aladin,

I agree that things are always worth reconsidering, but even if Pierre
really believes what he states, and after hearing him and looking at his
website I am sure he does, there have been occasions where he was
inaccurate, and SUMPRODUCT is not the answer to life, the universe and
everything.

It is one thing to offer a solution to a particular problem, even if that is
not the fastest, quickest or most elegant, it is completely another to then
put forward a proposition as offered in the original posting.

Bob

"Aladin Akyurek" wrote in
message ...

Bob Phillips Wrote:
I don't think this thread is worth continuing.
[...]
I suggest that a generic answer to everyone is to ignore this post,
and
understand that there are appropriate times to use SUMIF/COUNTIF,
appropriate times to use array formulae, appropriate times to use
VLOOKUP,
and appropriate times to use SUMPRODUCT. There is no universal theory
of
everything in Excel formulae :-).
[...]

Au contraire. Pierre Leclerc, for all we know, might believe what he
states. There are lots of spreadsheet users who end up thinking the
same, seeing 'thousends of Sumproduct or array formulas' offered by us
here and elsewhere. More often than not without concern for efficiency
and robustness. Leclerc's post is an excellent occasion to re-consider
such matters.


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile:
http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=319150